Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 01 Apr 2004 @ 10:09:21 GMT

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

Subj:   Re: Hexadecimal value for char-Mload error
From:   Dieter Noeth

Rohini S wrote:

  In my Mload,i have a decimal field which has an indicator field following to specify if it is nullable.  

  When it is nullable,(i.e the ind value = '?'),the decimal field stores low values.  

What do you mean by "low values"?

  So,my layout definition of reading that value as decimal(15,0) does not work (rows would go into ET)  

  Neither am I able to read as char and cast it , as rows would go into UV for failure in conversion from char to numeric function.  

How about:

.FIELD x * DEC(15,0) NULLIF y = '?';
.FILLER y * CHAR(1);

Could you post your current .LAYOUT?


  <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