SQL INSERT scalar function in DB2 for i SQL SQL INSERT scalar function in DB2 for i SQL INSERT The INSERT function returns a string where beginning at start in source-string, length charact…
SQL IFNULL scalar function in DB2 for i SQL SQL IFNULL scalar function in DB2 for i SQL IFNULL The IFNULL function returns the first nonnull expression. Syntax IFNULL(expression1, expre…
SQL IDENTITY_VAL_LOCAL scalar function in DB2 for i SQL SQL IDENTITY_VAL_LOCAL scalar function in DB2 for i SQL IDENTITY_VAL_LOCAL The IDENTITY_VAL_LOCAL function returns the most recently assigned val…
SQL HOUR scalar function in DB2 for i SQL SQL HOUR scalar function in DB2 for i SQL HOUR The HOUR function returns the hour part of a value. Syntax HOUR(expression) The argument sho…
SQL HEX scalar function in DB2 for i SQL SQL HEX scalar function in DB2 for i SQL HEX The HEX function returns a hexadecimal value as a character string. Syntax HEX(expression) wh…
SQL GREATEST scalar function in DB2 for i SQL SQL GREATEST scalar function in DB2 for i SQL GREATEST The GREATEST function returns the maximum value in a set of values. Syntax GREATEST(a…
SQL GRAPHIC scalar function in DB2 for i SQL SQL GRAPHIC scalar function in DB2 for i SQL GRAPHIC The GRAPHIC function returns a fixed-length graphic string of a value of different data type…
SQL FLOOR scalar function in DB2 for i SQL SQL FLOOR scalar function in DB2 for i SQL FLOOR FLOOR function is also called as greatest integer function and returns the largest integer less …
SQL FIRST_DAY scalar function in DB2 for i SQL SQL FIRST_DAY scalar function in DB2 for i SQL FIRST_DAY The FIRST_DAY function returns the 1st day of the month of the passed argument. Synt…
SQL EXTRACT scalar function in DB2 for i SQL SQL EXTRACT scalar function in DB2 for i SQL EXTRACT The EXTRACT function returns a portion of a date or timestamp based on its arguments. The…
SQL DIGITS scalar function in DB2 for i SQL SQL DIGITS scalar function in DB2 for i SQL DIGITS The DIGITS function returns a absolute value character string of a number. Syntax DIGITS(n…
SQL DECIMAL or DEC scalar function in DB2 for i SQL SQL DECIMAL or DEC scalar function in DB2 for i SQL DECIMAL or DEC The DECIMAL function returns a decimal value of either a number, or character…
SQL DAYS scalar function in DB2 for i SQL SQL DAYS scalar function in DB2 for i SQL DAYS The DAYS function returns an integer representation of a date. The result is 1 more than the num…
SQL DAYOFYEAR scalar function in SQL DB2 for i SQL DAYOFYEAR scalar function in SQL DB2 for i DAYOFYEAR The DAYOFYEAR function returns an integer from 1 to 366 i.e. day of the year where 1 i…
SQL DAYOFWEEK scalar function in SQL DB2 for i SQL DAYOFWEEK scalar function in SQL DB2 for i DAYOFWEEK The DAYOFWEEK function returns an integer from 1 to 7 i.e. day of the week where 1 is Su…
SQL DAY scalar function in DB2 for i SQL SQL DAY scalar function in DB2 for i SQL DAY The DAY function returns the day part of a value. Syntax DAY(expression) The argument should…
SQL DATE scalar function in DB2 for i SQL SQL DATE scalar function in DB2 for i SQL DATE The DATE function returns a date that is derived from a value. Syntax DATE(expression) The a…
SQL CONCAT scalar function in DB2 for i SQL SQL CONCAT scalar function in DB2 for i SQL CONCAT The CONCAT function combines two arguments to form a string expression. Both the arguments mus…
SQL COALESCE scalar function in Db2 for i SQL SQL COALESCE scalar function in Db2 for i SQL COALESCE The COALESCE function returns the value of the first Non-Null expression. The result could…