Dynamic query in oracle stage
Posted: Wed Aug 27, 2003 3:34 pm
Hi,
Is there any way to handle dynamic queries in a oracle stage? For example, I have a server job say Job1 whose source oracle stage has a query to fetch some number of records. Now, I will run a unix script to execute my jobs starting with Job1 and rest all jobs follow this. Now, is it possible to form the query in the Job1's oracle stage based on some parameters from unix script?
I have tried copying the same job with a different name and tried to use job parameters to form the query and couldn't succeed.
Could anybody clarify the approach to be followed in terms of DataStage for this scenario? (Probably this scenario could be represented in a different way when we think this design in DataStage)
Thanks in advance,
Srinivas.
Is there any way to handle dynamic queries in a oracle stage? For example, I have a server job say Job1 whose source oracle stage has a query to fetch some number of records. Now, I will run a unix script to execute my jobs starting with Job1 and rest all jobs follow this. Now, is it possible to form the query in the Job1's oracle stage based on some parameters from unix script?
I have tried copying the same job with a different name and tried to use job parameters to form the query and couldn't succeed.
Could anybody clarify the approach to be followed in terms of DataStage for this scenario? (Probably this scenario could be represented in a different way when we think this design in DataStage)
Thanks in advance,
Srinivas.