Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Oct 2001 @ 20:09:39 GMT


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


Subj:   Re: 38 position NUMERIC field?
 
From:   Michael Larkins

My first question is: are they allows leading zeroes?

If so, define the leading zeroes as junk char(??). Then, define the good data as a DECIMAL(??) and use it for the PI data for each row. Remember to ignore the junk.

If this (leading zeroes) is not the case, define it as two separate fields. Then, multiply the first field by 10000?? (whatever to account for digits) and add the two fields together. This is how Teradata handles a date for combining hours, minutes and seconds.

the problem here is that you might end up with a DECIMAL larger than 18 digits.

Best of luck,

Mike



     
  <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