Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 08 Feb 2011 @ 16:00:10 GMT


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


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

Hi,

Iam using the below source file, table structure and the Tpump script. Iam getting the below error while loading to the table.

**** 21:06:49 UTY1419 The field type for field ACCOUNT_NUMBER is not allowed when using the VARTEXT record format.


Can anyone please let me know what changes to be done for the script/table, so that it should script will work.

     TpumpSource.txt
     ACCOUNT_NUMBER,STREET,STATE,ZIP_CODE
     20030840,Pier Avenue ,CA,94123
     20025559,Budlong Ave ,CA,90066
     20031982,Carson Plaza ,CA,90365
     20031039,Brookshire Avenue ,CA,94123

     Table Structure
     CREATE SET TABLE TableName, NO FALLBACK ,
      Account_Number CHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC,
      Street CHAR(18) CHARACTER SET LATIN NOT CASESPECIFIC,
      State CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
      Zip_Code CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC ) MyScript .logtable
     Database.Tablename;
     .logon demotdat/dbc, dbc;
     .begin load
             ERRLIMIT 5
             CHECKPOINT 50
             TENACITY 2
             PACK 5
             RATE 10
             sessions 4
             ERRORTABLE Database.Tablename;
     .LAYOUT ggclilayout;
     .FIELD ACCOUNT_NUMBER   * char(10);
     .FIELD STREET           * VARCHAR(100);
     .FIELD STATE            * VARCHAR(100);
     .FIELD ZIP_CODE         * VARCHAR(100);
     .dml label INSERTCLI;
     insert into Database.TableName ( Account_Number, Street CHAR,State
     CHAR,Zip_Code) VALUES  ( :Account_Number,:Street,:State,:Zip_Code);
     .IMPORT INFILE C:\BTEQ\TpumpSource.txt
     FORMAT VARTEXT ','
     layout ggclilayout
     apply INSERTCLI;
     .end load;
     .logoff;

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: 27 Dec 2016