DSXchange

Hi
I am using a column import stage to convert a single column to multiple columns. I am using a schema file to create the metadata for the output. Are there any ways in which i can define the order in which the columns needs to appear in the output

Eg I have a member number column and balance column(needs to be imported).
Output from import stage is something
like this
Bal1,Bal2,Bal3,Member_number

I need to get the ouput in this way
Member_Number,Bal1,Bal2,Bal3

Any suggestions?

swerajan wrote:
I need to get the ouput in this way
Member_Number,Bal1,Bal2,Bal3

Why do you need them in that order out of the import stage? It shouldn't really matter what order the columns appear.

Or are you outputting the values into a file of some description?

I am loading the data into the table so if the order is maintained it would be good.

swerajan wrote:I am loading the data into the table so if the order is maintained it would be good.

What is the target? And how are you loading?

The target is a DB2 table which will contain the structure something like this
MemberNo~Bal1~Bal2~Bal3~Bal4

The load is a daily load with updates and inserts happening regularly.

Not really an answer, per se, but do you not realize that the order you mention those columns in your DML will make absolutely no difference to the result?