DSXchange

I have a parameter file having values for Month_No, Week_NO. I want to use this values in my SQL Query WHERE Class during extraction from oracle table. How can i read this values from file and pass that to SQL.

Suresh

You should ask this questions to one who introduced you to this forum. You will get your answers.

Why everybody is wondered b'cos, before ask about any doubt use manuals then your doubt will be resonable. try to use then raise your doubt. Simply during the runtime job needs some variable to hold the environment values. For example - Your source DB details, Target DB details, Application Id, Run ...