Archives of the TeradataForum

Message Posted: Fri, 21 Apr 2006 @ 19:41:42 GMT

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

Mohan,

Please find the Sample Script for Tab Delimited :

     /* TP ID, UserName and Password */
      

     /* Deleting Records from Table */
      DELETE FROM  ;

     /* Dropping Error Tables */
     DROP TABLE ;

     DROP TABLE ;

     /* Specifying the Type of File */
     .SET RECORD VARTEXT "   " ;

     /* Defining the Columns in Flat File Format */
     DEFINE
             Column1 (varchar(size of the attribute)),
             Column2 (varchar(size of the attribute)),
             .
             .
     /* Loading from Input File */
     FILE =;

     BEGIN LOADING   ERRORFILES
     ,


     /* Inserting Rows into the Table*/
     INSERT INTO 
     (
              Column 1,
              Column 2,
                .
                .
     )
     VALUES
     (
              :Column 1,
              :Column 2,
                .
                .
     );

     /* Finishing the Loading */
     END LOADING;

     .LOGOFF;

     .QUIT;

     EOF

With regards,

Dhanabal S.

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