Usage Notes - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
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.