 |
 |
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. | |
How about:
.FIELD x * DEC(15,0) NULLIF y = '?';
.FILLER y * CHAR(1);
Could you post your current .LAYOUT?
Dieter
| |
