Usage Notes - Parallel Data Pump

Teradata Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-22
dita:mapPath
tqa1488824663174.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 Teradata Database for a UNIX OS.