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)
reading a fixed width file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.