Access Excel file and Fixed width file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

Access Excel file and Fixed width file

Post by deesh »

Hi Friends,

How to access the Excel file (Source), May its like to import through sequencial file definition or some other plug-in side. Can explain to me.

How define the fixedwidth file, I have little bit doubt, Please explain this one also.
mail2hfz
Premium Member
Premium Member
Posts: 92
Joined: Thu Nov 16, 2006 8:51 am

Post by mail2hfz »

Please do a search on the forum. This has been discussed many times before. Following links might help.
viewtopic.php?t=122195&highlight=excel+file

viewtopic.php?t=121586&highlight=excel+file

for fixed width file creation try to set the following.
Record Level Properties
Record length = fixed
Field defaults
Delimiter = none
Post Reply