Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Feb 2011 @ 09:26:41 GMT


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


Subj:   Re: TPUMP script error: UTY1419 The field type is not allowed
 
From:   Shindhe, Naveen

Thanks for the reply.

I am able to load the values from the flat file to the table via Tpump.

The issue is the below flat file header also is inserting in the table. How to avoid this.


Source.txt

     ACCOUNT_NUMBER,STREET,STATE,ZIP_CODE
     20030840,Pier Avenue ,CA,94123
     20025559,Budlong Ave ,CA,90066

Tables Values

     20027590   Madrona Ave          CA   90020
     ACCOUNT_   STREET               ST   ZIP_C

I have defined the layout as below

     .FIELD ACCOUNT_NUMBER    * VARCHAR(100);
     .FIELD STREET       * VARCHAR(100);
     .FIELD STATE       * VARCHAR(100);
     .FIELD ZIP_CODE    * VARCHAR(100);

Thanks



     
  <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