Archives of the TeradataForum
Message Posted: Thu, 01 Apr 2004 @ 10:09:21 GMT
| 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.|| |
.FIELD x * DEC(15,0) NULLIF y = '?';
.FILLER y * CHAR(1);
Could you post your current .LAYOUT?