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.
