Archives of the TeradataForum

Message Posted: Tue, 04 May 2004 @ 17:06:28 GMT

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

Since your MLOAD scripts apparently do not specify an explicit FORMAT for the input and you want the DDL "FORMAT" clause to be implicitly used in the date conversion, your session(s) must use INTEGERDATE. (ANSIDATE means the implicit format is always assumed to be 'YYYY-MM-DD'.)

One solution would be to use ".DATEFORM INTEGERDATE;" prior to the LOGON in all your MLOAD scripts; that will work on both systems. But that's nearly as much work as adding explicit FORMAT clauses to the input LAYOUTs. if you don't want to change the scripts, MODIFY the default date format for the appropriate username(s) on the new system.

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