Archives of the TeradataForum

Message Posted: Fri, 17 Oct 2003 @ 23:06:25 GMT

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

Fastload does support multiple nullif's . Here's an example (fastload .ctl generated by Informatica) :

define
ITEM_ID (CHAR(20) ),
ITEM_SITE_ID (CHAR(20) , NULLIF = '*'),
LEAF_CATEG_ID (CHAR(20) , NULLIF = '*'),
AUCT_TYPE_CODE (CHAR(20) , NULLIF = '*'),
HIGHEST_PAGE (CHAR(20) , NULLIF = '*'),
CURRENT_PAGE (CHAR(20) , NULLIF = '*'),
CATALOG_ID (CHAR(32) , NULLIF = '*'),
CREATED (CHAR(26) , NULLIF = '*'),
LAST_MODIFIED (CHAR(26) , NULLIF = '*'),
LISTING_TIME (CHAR(26) , NULLIF = '*'),
newlinechar (CHAR(1))
file=/export/home/bogus/file.dat

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