 |
 |
Archives of the TeradataForum
Message Posted: Tue, 06 Apr 2004 @ 12:59:56 GMT
| 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;
| |
