BMC AMI Unload TIMESTAMP

This keyword specifies a timestamp field and must be specified as one of the following TIMESTAMP specifications:

TIMESTAMP EXTERNAL(length)

This option specifies a Db2 timestamp string value.

Precision on a TIMESTAMP EXTERNAL field is the specified length minus 20. The following additional information applies to the precision of the timestamp value:

  • If the length is less than 21, BMC AMI Unload sets the precision to 0 and the length to 19.
  • If the length is greater than 32, BMC AMI Unload sets the precision to 12 and pads the result with blanks.
  • If the length of the TIMESTAMP column is greater than the calculated precision of the TIMESTAMP field, BMC AMI Unload truncates the seconds fractions.
  • If the length of the TIMESTAMP column is less than the calculated precision of the TIMESTAMP field, BMC AMI Unload extends the seconds fractions with zeros.

Related topics

BMC-AMI-Unload-field-specification
BMC-AMI-Unload-field-specification

SELECT statement options (UNLOAD syntax)

BMC AMI Unload option descriptions
BMC-AMI-Unload-Option-descriptions

UNLOAD-syntax-diagrams

TIMESTAMP WITH TIME ZONE EXTERNAL(length)

This option specifies a Db2 timestamp with a time zone string value. BMC AMI Unload extracts the time zone from DSNHDECP, if specified, or from the IBM z/OS communication vector table (CVT).

Precision on a TIMESTAMP WITH TIME ZONE EXTERNAL field is the specified length minus 26. The following additional information applies to the precision of the timestamp value:

  • If the length is less than 27, BMC AMI Unload sets the precision to 0 and the length to 25.
  • If the length is greater than 38, BMC AMI Unload sets the precision to 12 and pads the result with blanks.
  • If the length of the TIMESTAMP column is greater than the calculated precision of the TIMESTAMP field, BMC AMI Unload truncates the seconds fractions.
  • If the length of the TIMESTAMP column is less than the calculated precision of the TIMESTAMP field, BMC AMI Unload extends the seconds fractions with zeros.


 

  • 13.1
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*