I am trying to read excel sheet in Sequentail file and writing it to DB2.
Am getting all the junk data in the view data(Seq file) and also it is showing less no of records.
TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 1, column LF_ID, required column missing
TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 2, too many columns in record
TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 3, column LF_ID, required
You can't use a Sequential File stage to read a spreadsheet unless you've saved it in .csv format first. To read the .xls directly you need to use the ODBC stage instead.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Like Craig said you should convert the excel file to a .csv file and also the no of columns and column length in the sequencial file stage should match the csv file, otherwise you would get the error you mentioned.