Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 01 Jun 2000 @ 14:45:08 GMT


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


Subj:   Re: Loading Packed data to A Date column
 
From:   Simon Norris

If the data on input is stored as ' 7' and you want the data loaded to a numeric column it may be best to DEFINE the field as a CHAR(04) but load it to an integer column and let Teradata do the conversion.

There may be a need to put a FORMAT of 'ZZZ9' on the column in the VALUE clause. I'll check out some code at work today and let you know.


Simon Norris



     
  <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