Reading a parameter file and pass that values to SQL query

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Arockiyam
Participant
Posts: 3
Joined: Mon Dec 10, 2007 5:59 am
Location: Kuttapuly

Reading a parameter file and pass that values to SQL query

Post 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.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “General”