The DateTime results type specifies the format that the DB2 UDB Option for CICS uses to return DB2 timestamp, time, and date result columns to TRS or non-DB2 access service connections. Three values are valid:
DB2 (the default) returns timestamps in the standard DB2 timestamp format of YYYY-MM-DD-HH.MM.SS.ssssss, where YYYY indicates the year, MM indicates the month, DD indicates the day, HH indicates the hour, MM indicates the minute, and SS.ssssss indicates the seconds. For example, a DB2 value might return 2002-05-14-1.42.22.123456.
TRO returns timestamps in a format compatible with ASE/CIS communication with DirectConnect for z/OS Option TRS using the ASE/CIS Access Server Class.
TRO format is YYYYMMDD HH:MM:SS:ss, where the abbreviations are similar to the DB2 abbreviations. Using the example from the DB2 value, the TRO value returns 20020514 1:42:22:12.
ISO returns timestamps in the ISO (International Standards Organization) format of YYYY-MM-DD hh.mm.ss, where the abbreviations are similar to the DB2 UDB abbreviations. Following the previous examples, an ISO value might return 2002-05-14 13.42.22.
