Archives of the TeradataForum

Message Posted: Mon, 26 Jul 2004 @ 07:56:07 GMT

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

Hi

Use NULLIF in the layout

Like this,

     .LAYOUT MIXED_FORMAT ;
     .FIELD FIELD1 * VARCHAR(100);
     .FIELD FIELD2 * VARCHAR(100) NULLIF FIELD2 = '' ;
     .FIELD FIELD3 * VARCHAR(100) NULLIF FIELD3 = '' ;
     .FIELD FIELD4 * VARCHAR(100) NULLIF FIELD4 = '' ;

And accordingly define the DML to populate you tabels.

Then in the IMPORT use the correct DML label with APPLY WHERE condition.

Hope this helps!

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