Running source query at runtime

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
kamalshil
Participant
Posts: 179
Joined: Mon Jun 23, 2008 1:19 am

Running source query at runtime

Post by kamalshil »

Hi ,

I have 3 queries and i have to run any one query in source stage depending upone the value of parameter?

Can this be done or i have to use 3 ODBC stage to do so?
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

if the the metadata for output are same then it can be done in one query using union
kamalshil
Participant
Posts: 179
Joined: Mon Jun 23, 2008 1:19 am

Post by kamalshil »

Thanks,
This solved my problem by using union
Post Reply