Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Apr 2004 @ 12:59:56 GMT


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


Subj:   Re: Hexadecimal value for char-Mload error
 
From:   Geoffrey Rommel

> field f1 decimal(15,0);
> field f1_ind char(01);
  the problem comes when the field f1 is null.When it is null,the I/P file does not have the value in decimal format(in lowest terms my hex on does not have anything ending with 'C' or 'D' in my file ).So,i would not be able to read them as decimal(15,0).  


Would this work?

     field f1  decimal(15,0)  nullif f1='0000000000000000'x;


     
  <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: 15 Jun 2023