Archives of the TeradataForum

Message Posted: Tue, 27 Mar 2007 @ 17:04:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- 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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>