Column Export Stage Work around

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
dsnk
Premium Member
Premium Member
Posts: 10
Joined: Fri Jun 15, 2012 12:11 am
Location: USA

Column Export Stage Work around

Post by dsnk »

I have a requirement to create a pipe delimited sequential file out of a table extract. I have a table with 150 columns and I'm using column export stage to cretae the file. In this process, I have to go look the order of columns and select from the properties , manually add each column in the same order as in the table.
Its really difficult to select each column manually. Also, there are instances where we are missing one column and the whole order changfes in the ouput file.
Is there any way to avoid this effort and have the column export be done in a simple way ensuring the sequence of columns selected in export is same as the source?

Please help
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Re: Column Export Stage Work around

Post by ray.wurlod »

dsnk wrote:Its really difficult to select each column manually.
No it's not. Be vigilant.

<Apostrophe Man>
It's "it's" when it's "it is", and it's "its" any other time.
</Apostrophe Man>
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
BI-RMA
Premium Member
Premium Member
Posts: 463
Joined: Sun Nov 01, 2009 3:55 pm
Location: Hamburg

Post by BI-RMA »

Another option is to use a schema-file containing the columns in the correct order.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
Post Reply