|
|
Archives of the TeradataForum
Message Posted: Wed, 06 Nov 2002 @ 17:34:22 GMT
Subj: | | Re: INDICATORS FIELD in FastLoad Script |
|
From: | | Reddy, Ponnolu |
comments are embedded
| 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. | |
I am refering FastLoad 07.05.00 manual... I didn't see this info
| Anyway, another thing to try is the NULLIF option. This gets added to the field definitions within the DEFINE clause and
effectively says that "if the input field contains the NULLIF value, treat that as a NULL". So something like | |
| col1 (integer, nullif = 0) | |
| will treat a 0 value in the col1 input field as if it was NULL. | |
That is fine....
I just want to findout the usage of INDICATORS
how to use....
does anybody have any idea?
| |