Tuesday, March 23, 2010

My SYSDUMMY1 has turned DUAL

For ages I have used the SYSDUMMY1 view to evaluate simple expressions or retrieve registry variables (some of that could have been done using the VALUES expression). It seems that I will switch to a shorter version of it and in the future will most of the times use DUAL (SYSIBM.DUAL).

Once the DB2_COMPATIBILITY_VECTOR includes 0x02, you can even leave out the SYSIBM schema and just use DUAL:

db2 => select current_date from dual


  1 record(s) selected.