AS400 and SQL Tricks

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 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 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 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 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 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 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 COALESCE The COALESCE function returns the value of the first Non-Null expression. The result could…

SQL CHAR scalar function in DB2 for i SQL CHAR The CHAR function returns a fixed length character string of the passed expression. The passed expr…

SQL CEILING or CEIL scalar function in DB2 for i SQL CEILING or CEIL The CEILING function returns the smallest integer value that is greater or e…

SQL ASCII scalar function in DB2 for i SQL ASCII The ASCII function returns the decimal value of the leftmost character of the character string/…

ASCII Table ASCII Table Her Dec represents Decimal value and Char represents character value.

ADD_MONTHS scalar function in DB2 for i SQL ADD_Months The ADD_Months function returns a date after adding specified months to it. ADD_MONTHS…

SQL ABS or ABSVAL scalar function in DB2 for i SQL ABS or ABSVAL The ABS or ABSVAL function returns the absolute value of a number. ABS(Numeri…

SQL DELETE Statement in DB2 for i SQL The DELETE statement is used to delete the existing rows in a table. DELETE syntax DELETE FROM table_name…

SQL UPDATE Statement in DB2 for i SQL The UPDATE statement is used to modify the existing records in a table or a view. UPDATE syntax UPDATE ta…

Inserting rows using a select-statement in DB2 for i SQL We can use SELECT statement within an INSERT statement to insert rows into the table spec…

SQL INSERT INTO Statement in DB2 for i SQL The INSERT INTO statement is used to insert single or multiple records in a table or view. Syntax us…

FETCH FIRST clause in DB2 for i SQL FETCH FIRST clause is used to specify the number of rows to return in the SELECT statement. Syntax using FET…