DSXchange

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.

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*

Right... SQL files do not support #parameters# in them so you've got to build / rebuild the file each run with any parameter values subsituted in.

*throws another penny in the cup*