DSXchange

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.

If you have a preprocessing script like Shell/perl script, You can also convert the file as a delimited file and read it from the sequential file stage.

You can do it separately in a shell script to remove the unwanted lines and then invoke the dsjob. I was wondering how could we skip a pre-determined number of lines in a sequential file? We have integrity checks such as no. of rows of data and\or checksum of the file, marked up at the very end (or ...

Hi, We have a situvation where we need to convert more than 1000 DB2 tables to Oracle tables which has huge data. I know that we can do the DB2toOracle Conversion for each table one by one. But since the table volume and number is more I would be interested if anyone knows a better way to convert th...