Generating different `current timestamps` in a single Statement

Topic: Code Place

Subtopic: Cross Platform

All CURRENT TIMESTAMPs in a single SQL Statement return the same value, irrespective of whether when the different values are generated. The code sample shows how to generate unique `CURRENT TIMESTAMP`s in the same SQL Statement.

The example is for DB2 LUW and does not directly execute on DB2 z/OS, but the idea of using function generate_unique() can be applied identically.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.