Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 05 Apr 2004 @ 08:21:08 GMT

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

Subj:   Re: Hexadecimal value for char-Mload error
From:   Rohini S


As per Victor's suggestion-iam reframing my question from scratch !

I have a nullable decimal field in in my input file for mload(decimal(15,0).

It is not recommended to use nullif statements in my mload as they cause CPU overhead. So,instead of nullif ,i can use case.


     field f1 decimal(15,0);
     field f1_ind char(01);

my insert would be like

case when f1_ind = '?' then null else f1.

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 decimla(15,0).It would fail and rows go into error table.

I cannot use char also for reading it - as decimal read as char cannot insert proper values even if i cast !

  <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