Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Multiload Problem With Date Columns - V2R5.1
 
From:   Fred W Pluebell

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