Page 1 of 1

Reading a parameter file and pass that values to SQL query

Posted: Mon Mar 03, 2008 12:33 am
by Arockiyam
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.

Posted: Mon Mar 03, 2008 12:34 am
by ray.wurlod
In a job sequence. You're not the first to ask, so try searching the forum. It's a good source of ideas and techniques.