The DATEFORM command specifies the form of the DATE data type specifications for the FastExport job.
where:
Syntax Element |
Description |
ANSIDATE |
Keyword that specifies ANSI fixed‑length CHAR(10) DATE data types for the FastExport job |
INTEGERDATE |
Keyword that specifies integer DATE data types for the FastExport job. This is the default specification for FastExport jobs if a DATEFORM command is not entered. |
Table 27 describes the things to consider when using the DATEFORM command.
Topic |
Usage Notes |
Command Frequency and Placement |
Only one DATEFORM command can be used. The command must be entered before the LOGON command. |
Data Type Conversions |
When the ANSIDATE specification is used, ANSI/SQL DateTime data types must be converted to fixed‑length CHAR data types when specifying the column/field names in the FIELD command. For each DATE, TIME, TIMESTAMP, and INTERVAL data type specification, see “FIELD” on page 84 for a description of the fixed‑length CHAR representations. |