Hi,
I am running the sql query using "read select statement from file" in Oracle connector stage and I need to pass job's parameter value to this query at run time like extract date.
Can you suggest how we can pass the Parameter to sql query at run time.
I am using DS 8.5 version.
Passing Job Parameter value in Oracle Connector Stage query
Moderators: chulett, rschirm, roy
Sequencer the process.
Step 1) Have a script parse the text file first and string replace the tags with your environment variables being passed in. Output is a new text file coded with unique timestamp or runid for this execution.
Step 2) Take the NEW text file containing the massaged sql statement and pass that to your next job.
Step 3) Delete temp text file if job ran ok.
*drops 2 cents into cup*
Step 1) Have a script parse the text file first and string replace the tags with your environment variables being passed in. Output is a new text file coded with unique timestamp or runid for this execution.
Step 2) Take the NEW text file containing the massaged sql statement and pass that to your next job.
Step 3) Delete temp text file if job ran ok.
*drops 2 cents into cup*