IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5

Time type

Byte order. Specifies how multiple byte data types are ordered. Choose from:
- little-endian. The high byte is on the right.
- big-endian. The high byte is on the left.
- native-endian. As defined by the native format of the machine.
Character Set. Choose from ASCII or EBCDIC.
Default. The default value for a column. This is used for data written by a Generate stage. It also supplies the value to substitute for a column that causes an error (whether written or read).
Data Format. Specifies the data representation format of a column. Choose from:
- binary
- text
  For time, binary is equivalent to midnight_seconds, text specifies that the field represents time in the text-based form %hh:%nn:%ss or in the default date format if you have defined a new one on an NLS system.
Format string. Specifies the format of columns representing time as a string. By default this is %hh-%mm-%ss. For details about the format, see Time formats
Is midnight seconds. Select this to specify that times are written as a binary 32-bit integer containing the number of seconds elapsed from the previous midnight.

This topic is also in the IBM InfoSphere DataStage and QualityStage Parallel Job Developer's Guide.

Update timestamp

Last updated: 2012-10-8