Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Multiload Problem With Date Columns - V2R5.1
 
From:   PriceJ

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016