Data Format
If a COBOL output host variable is defined for an SQL timestamp value with an offset, the date and time are specified in the
following format:
yyyy-mm-dd hh:mm:ss[.f[f[...]]] {+ | -}hh:mm
where the number of fractional digits is driver-defined. For example:
1994-05-24 12:34:00.000 +02:00
Host Variable Formats
- OpenESQL and DB2 ECM
-
01 timestampoffset1 PIC X(36).
- OpenESQL
-
01 timestampoffset2 SQL TYPE IS TIMESTAMP-OFFSET.
01 timestampoffset3 SQL TYPE IS TIMESTAMP-OFFSET-RECORD.
- The
timestampoffset2 format uses the TIMESTAMP-OFFSET SQL TYPE.
- The
timestampoffset3 format uses the TIMESTAMP-OFFSET-RECORD SQL TYPE.
- OpenESQL
JVM Managed Runtime
- In addition to the definitions valid for all databases and those valid for OpenESQL, the following definition is also valid
for the OpenESQL
JVM Managed Runtime:
01 timestampoffset4 type System.DateTimeOffset.