Wednesday, 15 May 2019

[Db2 LUW] Source for arbitrary record

I sometimes are in need for a source of an arbitrary record, e. g. to test some function. In Oracle you can use DUAL. In Db2 LUW (to make it clear what DB I am referring to, I know LUW is officially not used anymore by IBM) there is a compatibility vector thing which provides DUAL as well. But it is not installed, switched on, activated or whatever one has to do to make it usable, one can use SYSIBM.SYSDUMMY1.

No comments:

Post a Comment

[git] Create a local branch from another branch

From the active branch git checkout -b <LOCAL_BRANCH> From a donator branch git checkout -b <LOCAL_BRANCH> <DONATING_BRANCH...