Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 19:11:55 GMT

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

Reddy,

I wouldn't have thought that the "Indicators" keyword will work unless you use the default record format. Having said that, the manual only says that Indicators cannot be used if record format is vartext. So who knows.

Anyway, another thing to try is the NULLIF option. This gets added to the field definitions within the DEFINE clauseand effectively says that "if the input field contains the NULLIF value, treat that as a NULL". So something like

Define col1 (integer, nullif = 0)

will treat a 0 value in the col1 input field as if it was NULL.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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