Archives of the TeradataForum

Message Posted: Tue, 04 May 2004 @ 14:16:21 GMT

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

We have just brought up a new NCR 4980 server running V2R5.1.

We are having a problem with date columns in that our MultiLoad scripts, which run fine on our 4855 under V2R4.1.3, are erroring out on "invalid date" under V2R5.

The format of the incoming values is CHAR(8) mmddyyyy. The DDL has a FORMAT 'mm/dd/yyyy' for all date columns.

We reset the DateForm parameter in DBSCONTROL to 1 (ANSIDate), but that didn't help.

Can anyone advise as to what next? We're trying to avoid having to create separate copies/versions of the scripts for each server/RDBMS.

Thanks in advance.

Jackson

Jackson Price
American Red Cross
Data Warehouse & Decision Support Systems

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