![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Fri, 30 Aug 2002 @ 13:30:47 GMT
Subj: | | Re: NULLIF problem in TPUMP |
|
From: | | Geoffrey Rommel |
| I have to load NULL into a date field if the input has '?'. The code is | |
| .FIELD SALES_TRANS_DT * CHAR (08) NULLIF SALES_TRANS_DT = '?'; | |
| Note that the input is a text field of length 8 bytes. If the input field has ? in the first byte, the TPUMP works. If the ? is in
any other position other than the first byte, TPUMP writes the error log with the message "Invalid date supplied for
TEST11.SALES_TRANS_DT." | |
That's what I would expect. Since the field is character, comparing it to '?' is equivalent to comparing it to '? '.
You probably can't say "nullif position('?' in sales_trans_dt) > 0", so you will have to clean up the input before running TPump.
| |