Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 17:34:22 GMT


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


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  


  Define  


  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?



     
  <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