Archives of the TeradataForum

Message Posted: Thu, 15 Jun 2006 @ 11:27:38 GMT

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

Do You mean How to preserve null values in the table while carrying out the loading operation using fast load???

Using Keyword is not in the Fastload script but instead in Bteq script

Following is the code to load tables (preserving Nulls) using bteq

     IMPORT INDICDATA FILE=mydata;
     .REPEAT *
     USING col1(datatype), col2(datatype),  INSERT INTO TBname(:col1:col2);

For Fastload,,the script is:

     .logon xyz/dbname,password
     BEGIN LOADING TBName FILES e1,er2 indicators;
     DEFINE col1(datatype), col2(datatype)

     /* path where the datafile created using export command reside*/
     FILE=d:\scripts\data1;
     INSERT INTO TBname(:col1:col2);
     END LOADING;
     .logoff;

Cheers'

VG

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