SQL RAISE_ERROR scalar function in DB2 for i SQL SQL RAISE_ERROR scalar function in DB2 for i SQL RAISE_ERROR The RAISE_ERROR function return an error with the specified SQLSTATE along with SQL…
SQL QUARTER scalar function in DB2 for i SQL SQL QUARTER scalar function in DB2 for i SQL QUARTER he QUARTER function returns the quarter of the year in which the date resides i.e than int…
SQL POSSTR scalar function in DB2 for i SQL SQL POSSTR scalar function in DB2 for i SQL POSSTR The POSITION function returns the position of the first occurrence of the search string in th…
SQL POSITION scalar function in DB2 for i SQL SQL POSITION scalar function in DB2 for i SQL POSITION The POSITION function returns the position of the first occurrence of the search string in…
SQL NULLIF scalar function in DB2 for i SQL SQL NULLIF scalar function in DB2 for i SQL NULLIF The NULLIF function returns the null value if the two parameters are equal, otherwise it retur…
SQL MONTH scalar function in DB2 for i SQL SQL MONTH scalar function in DB2 for i SQL MONTH The MONTH function returns the month part of a value. Syntax MONTH(expression) The argum…
SQL MOD scalar function in DB2 for i SQL SQL MOD scalar function in DB2 for i SQL MOD The MOD function returns the remainder by dividing the first numeric expression by the second numeri…
SQL MINUTE scalar function in DB2 for i SQL SQL MINUTE scalar function in DB2 for i SQL MINUTE The MINUTE function returns the minute part of a value. Syntax MICROSECOND(expression) …
SQL MIN scalar function in DB2 for i SQL SQL MIN scalar function in DB2 for i SQL MIN The MIN function returns the minimum value in a set of values. We should pass at least 2 arguments.…
SQL MICROSECOND scalar function in DB2 for i SQL SQL MICROSECOND scalar function in DB2 for i SQL MICROSECOND The MICROSECOND function returns the microsecond part of a timestamp value. Syntax…
SQL MAX scalar function in DB2 for i SQL SQL MAX scalar function in DB2 for i SQL MAX The MAX function returns the maximum value in a set of values. We should pass at least 2 arguments.…
SQL LTRIM scalar function in DB2 for i SQL SQL LTRIM scalar function in DB2 for i SQL LTRIM The LTRIM function removes all of the characters that are passed in the trim-expression from the…
SQL LCASE/LOWER scalar function in DB2 for i SQL SQL LCASE_LOWER scalar function in DB2 for i SQL LOWER or LCASE The LOWER/LCASE function returns string where all the characters get converted in…
SQL LOCATE scalar function in DB2 for i SQL SQL LOCATE scalar function in DB2 for i SQL LOCATE The LOCATE function returns the position at which the first occurrence of search string starts…
SQL LENGTH scalar function in DB2 for i SQL SQL LENGTH scalar function in DB2 for i SQL LENGTH The LENGTH function returns the length of a value. Syntax LENGTH(expression) The expressi…
SQL LAST_DAY scalar function in DB2 for i SQL SQL LAST_DAY scalar function in DB2 for i SQL LAST_DAY The LAST_DAY scalar function returns the date which is the last day of the month of the pa…
SQL INTEGER or INT scalar function in DB2 for i SQL SQL INTERGER or INT scalar function in DB2 for i SQL INTEGER or INT The INTEGER function returns an integer value of either a number or a characte…
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…