I have am newly using the Fastload utility for loading data from CSV file to a table in Teradata. I am able to successfully load for 10 columns from CSV file to table .This is my Scenario1
When i am trying with an SECOND scenario of Loading 143 columns from CSV file to a table in Teradata I am unable to do it thru Fastload
Fastload is stopping in middle while displaying no error message
In the second scenario , the length of the column names are around 41 digits Example ABC_DEF_GHI_JKL_MNO_PQR_STU_123_456_789Q ABC_DEF_GHI_JKL_MNO_PQR_STU_123_456_789R ABC_DEF_GHI_JKL_MNO_PQR_STU
Fastload Script used for Scenario1 and able to load data successfully:- .LOGMECH LDAP .SESSIONS 4; LOGON servername/username,pwd: /* Drop Tables*/ drop table SCHEMA.TABLE1; drop table SCHEMA.TABLE1_ERR1; drop table SCHEMA.TABLE1_ERR2; CREATE TABLE SCHEMA.TABLE1 ( Col1 VARCHAR(100), Col2 INTEGER ); /*To Skip the header and provide the delimiter details*/ RECORD 2; SET RECORD VARTEXT ","; DEFINE in_Col1 (VARCHAR(30)), in_Col2 (VARCHAR(30)) /*FILE COMMAND DEFINES THE DATA FILE PATH AND NAME*/ FILE=path/sampl.csv; /*Begin Loading*/ BEGIN LOADING SCHEMA.TABLE1 ERRORFILES SCHEMA.TABLE1_ERR1,SCHEMA.TABLE1_ERR2; INSERT INTO SCHEMA.TABLE1 ( Col1=:in_Col1, Male_Cnt=:in_Male_Cnt ); END LOADING; LOGOFF;
Please provide me some inputs to resolve this issue for the Scenario2
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.