Order of Columns in Select Query and metadata!!!

sarathchandrakt · Post by **sarathchandrakt** » Mon Mar 23, 2015 9:36 am

Hi,

I am writing a select query in oracle connector.

Ex: Select A,B from tab1;

Do I need to write metadata in same order as that in the select statement?

A Varchar Etc...
B Varchar Etc...

As of now, I didn't face any problem different order. But I think I read it some where that it needs to be in same order. I am working on DS8.7

chulett · Post by **chulett** » Mon Mar 23, 2015 12:28 pm

First thing that comes to mind is why are you writing the SQL? If you let the Connector automatically generate it by setting Generate SQL at runtime to Yes, you won't have to worry about things like that. Provide the SQL only if it is something that the stage is incapable of generating.

That being said, it is my understanding that the matching in a PX job is done by name. In a Server job it would be by order.

oracledba · Post by **oracledba** » Mon Mar 23, 2015 3:09 pm

Yes have the metadata in the same order.

As craig explained if you have set Generate SQL at runtime then you dont have to worry about it.