Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 09 Oct 2001 @ 19:44:56 GMT

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

Subj:   Re: 38 position NUMERIC field?
From:   Geoffrey Rommel

  We are receiving a file where the data is pulled out of Oracle.  

You have my deepest sympathy.

  Apparently Oracle has the data defined as NUMERIC(38) and the field in the file is populated like this '00000000000000000000000000000000012345'....  

  Any suggestions on how to get this data into Teradata with the leading zeroes displayed as blanks?  

Can't you just ignore the leading zeroes when you load it? For instance, if this were the first field in the file, and you were loading it with FastLoad, you could say:

define filler01 char(20) ,bignumber char(18) ,...;

and then insert 'bignumber' into a DECIMAL(18) field. I assume you don't have any numbers of more than 18 digits; if you do, you won't be able to fit them into a FLOAT field anyhow.


  <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: 28 Jun 2020