Usage Notes - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table describes the things to consider when using the DATEFORM command.

DATEFORM Considerations 
Topic Usage Notes
Command Frequency and Placement Only one DATEFORM command can be used.

Enter the command before the LOGON command.

Data Type Conversions When the ANSIDATE specification is used, convert ANSI/SQL DateTime data types to fixed-length CHAR data types by specifying the column/field names in the Teradata MultiLoad FIELD command.

See the command usage notes for FIELD command description 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 MultiLoad jobs.