db2 Hello World; sample select query;


Example

SELECT 'HELLO WORLD' FROM SYSIBM.SYSDUMMY1;    

1          
-----------
Hello World

  1 record(s) selected.

"The SYSIBM.SYSDUMMY1 table contains one row. The table is used for SQL statements in which a table reference is required, but the contents of the table are not important"

this table has only one column. Column Name is IBMREQD. Default value is Y.

SELECT * FROM SYSIBM.SYSDUMMY1;
IBMREQD
-------
Y      

  1 record(s) selected.