Archives of the TeradataForum
Message Posted: Tue, 27 Mar 2007 @ 17:04:35 GMT
| Subj: || || Re: Using Coalesce in Multiload |
| From: || || Anomy Anom |
<-- Anonymously Posted: Tuesday, March 27, 2007 10:44 -->
Just FastExport with null indicator flags and tell MultiLoad there are null indicators.
Or if you like doing extra work, I suppose COALESCE on export and NULLIF on import would work - but since this is the PI you will need
MultiLoad to do the NULLIF on the client side (.FIELD) rather than using a function call in the SQL.