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
Order of Columns in Select Query and metadata!!!
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Fri Aug 29, 2014 1:32 pm
- Location: Mumbai
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers