Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 16:53:18 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Your BTEQ export and subsequent BTEQ IMPORT are implicitly and explicitly using Teradata default (BTET) dateform , whereas your fastload has ANSIDATE specified. The FASTLOAD input is expecting a different date data input.

From the FASTLOAD manual,

"....
Conversions

When you use the ANSIDATE specification, you must convert ANSI/SQL DateTime data types to fixed-length CHAR data types when specifying the column/field names in the FastLoad DEFINE command.

See the Usage Notes subsection of the DEFINE command description for a description of the fixed-length CHAR representations for each DATE, TIME, TIMESTAMP and INTERVAL data type specification.
......."

	<Prev	Next>		<<First	<Prev	Next>	Last>>