I have exported data from one server with '|' delimitter, now trying to load this same data to another server using fastload, during that time, I am getting below error.
" Error on piom GET ROW: 60, Text: Column length error, row not returned"
Did you check your input data? like if it has header....
You have not shared more information like your scripts. It may be that the data values witdh are bigger than the defined column width .
Hi Raja and sgarlapa,
Thank you for response. I have only exported data to a file and the same datatype legth I have used during the import also. All the column I have created as CHAR() datatype, will this is a problem? it should be varchar instead of CHAR?
There is no header in the file.
In DDL I have created all columns as CHAR(XX) (EX:Product_ID CHAR(10)) and in define part I have defined like below for all the columns(Instad of CHAR used VARCHAR(XX) and CHAR length)
Product_ID (VARCHAR(10) , NULLIF ='NULL' )
May be this is the problem :( If value is EXACT 10 CHARACTER length means, VARCHAR(10) will accomodate only 9 character and 1 character to keep exact length. Is it may understanding correct?
In My file total 1706678 record is there, if i try to load this file, i will get error as