Archives of the TeradataForum

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

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

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>>