Schema Files usage in Import stage - Help

[swerajan]

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?

[ShaneMuir]

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?

[swerajan]

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

[ShaneMuir]

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?

[swerajan]

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.

[chulett]

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?