Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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