I have created a SASfile with three variables/columns. PERSID (PD6), PRDID (PD6) and MANUF_LEGAL_ENTITY ($3.). In the next step in my job, I am using FASTLOAD to extract the data from this SASfile and create a table. See the JOB STEP and the respective SQL I am executing....
And below is the SQL Script: DATABASE CREDPOL; BEGIN LOADING CREDPOL.V772_LTSB ERRORFILES CREDPOL.V772_LTSB_ERROR1, CREDPOL.V772_LTSB_ERROR2 ; DEFINE PERSID (INTEGER) ,PRDID (INTEGER) ,MAN_LG_ENTY (CHAR(3)) DDNAME = INFILE ; SHOW; INSERT INTO CREDPOL.V772_LTSB VALUES( :PERSID ,:PRDID ,:MAN_LG_ENTY ) ; END LOADING;
The Teradata fastload is failing with the below message: 0007 INSERT INTO CREDPOL.V772_LTSB VALUES( :PERSID ,:PRDID ,:MAN_LG_ENTY ) ;
**** 12:28:37 Number of recs/msg: 235 **** 12:28:37 Starting to send to RDBMS with record 1 **** 12:28:37 RECORD is too long by 5876 byte(s) Field 1: 2078458338 Field 2: -742276638 Field 3:
I tried changing the third column definition to VARCHAR but still it is giving below error - **** 12:27:24 Number of recs/msg: 235 **** 12:27:24 Starting to send to RDBMS with record 1 **** 12:27:24 RECORD is too long by 5878 byte(s) **** 12:27:24 Possible cause: Variable size field may not contain 2-byte length or 2-byte length may be invalid.
Please help me!! I am stuck in defining the columns. Any clue?