Purpose
The DATEFORM command specifies the form of the DATE data type specifications for the Teradata FastLoad job.
Syntax
where
Syntax Element |
Description |
INTEGERDATE |
Keyword that specifies integer DATE data types for the Teradata FastLoad job. This is the default Teradata DATE data type specification for Teradata FastLoad jobs if a DATEFORM command is not entered. |
ANSIDATE |
Keyword that specifies ANSI fixed‑length CHAR(10) DATE data types for the Teradata FastLoad job. |
Usage Notes
Table 27 describes the things to consider when using the DATEFORM command.
Topic |
Usage Notes |
Command Placement and Frequency |
Only use one DATEFORM command. 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 Teradata FastLoad DEFINE command. See Table 28 for a description of the fixed‑length CHAR representations for each DATE, TIME, TIMESTAMP, and INTERVAL data type specification. |
Release Applicability |
The ANSIDATE specification is valid for Teradata FastLoad jobs. |