17.00 - Usage Notes - Parallel Data Pump

Teradata® Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-3021-220K

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

DATEFORM Command Usage Notes 
Topic Usage Notes
Command Frequency and Placement
  • Only one DATEFORM command can be used.
  • The DATEFORM command must be entered before LOGON command.
Data Type Conversions When the ANSIDATE specification is used, the ANSI/SQL DateTime data types must be converted to fixed-length CHAR data types when specifying the column/field names in the Teradata TPump FIELD command.

See the FIELD command 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 TPump jobs on the database for a UNIX OS.