Hi All,
Can anyone of you give hints how to read parameter from csv file.
I have value like this
Parameter name value
etl_run_date '2004-05-01'
etl_run_date '2005-05-01'
etl_run_date '2006-05-01'
etl_run_date '2007-05-01'
For first run, i want to use first parameter value, for second run i want to use second parameter value and so on.
I tried searching in archived but could not get desired information.
Any help or link to previous post would be helpful for me.
Much Appreciated.
Thanks
Reading parameter from csv file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Multiple instance job invoked thru a loop inside a sequence might be what you are looking for. Check out this discussion for more information :
http://dsxchange.com/viewtopic.php?p=23 ... 45c#236067
http://dsxchange.com/viewtopic.php?p=23 ... 45c#236067
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
(K)lasse is a guess what the "K" in your name stands for. Am I wrong?
Beside DataStage Jobs you can also develop DataStage Sequences. This might be a solultion for your problem.
An other a bit old fashion is to work with dsjob on your server, there you can nourish the parameters by job start.
Beside DataStage Jobs you can also develop DataStage Sequences. This might be a solultion for your problem.
An other a bit old fashion is to work with dsjob on your server, there you can nourish the parameters by job start.
Wolfgang Hürter
Amsterdam
Amsterdam
If you are on a 7.5.x version and thus have the new Start Loop, End Loop and UserVariables stages you can build a looping Sequence job. You would first get a list of your parameters from the file using the UserVariables stage and then it would pass them, one at a time, to your Loop that runs the processing job over and over until it runs out parameters.
Check the Server Job Developer's Guide for examples of the stages and their usage.
Check the Server Job Developer's Guide for examples of the stages and their usage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers