Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: INDICATORS FIELD in FastLoad Script
From:   David Wellman


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.



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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023