Archives of the TeradataForum
Message Posted: Tue, 04 May 2004 @ 14:16:21 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|