reading a fixed width file

[bhargav_dd]

i am new to datastage
i changed .xlsx file as a fixed width file.
when i use fixed width file as a source.
after import the metadata. by view data option it's not retrieving proper data.
(error: import short data)

[piyu]

An xls file is not a plain text file, it cannot be used directly in a file stage for read. Save it as txt file and then use it.

[ray.wurlod]

You can, alternately (if you have a UNIX-based ODBC driver for Excel), use ODBC to read from the worksheet. It is probably easier to script a mechanism for dumping the worksheet into CSV format (or similar), transfer that file to the UNIX machine, and have DataStage read the CSV file.