 |
 |
Archives of the TeradataForum
Message Posted: Mon, 19 Mar 2007 @ 21:50:40 GMT
| Subj: | | Re: NULLIF in .FIELD |
| |
| From: | | Dieter Noeth |
Ramu Kopuuravuri wrote:
| | I have specified NULLIF with blank condition for NOTNULL columns in MLOAD. But target table still have null values and those record's
logged in to error, seems NULLIF condition is not working. | |
> .FIELD IN_a * VARCHAR(1) NULLIF IN_a = ' ';
> .FIELD IN_b * VARCHAR(14);
> .FIELD IN_c * VARCHAR(6) NULLIF IN_c = ' ';
NULLIF IN_a = '';
| | And I try to use this NULLIF in INSERT clause like | |
> ,NULLIF(cast(:IN_a as CHAR(1)), ' ')
> ,NULLIF(cast(:IN_b as CHAR(1)), ' ')
NULLIF(trim(:IN_a), '')
Did you work with Oracle before?
Dieter
| |
