Reading parameters dynamically

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
shiva459
Premium Member
Premium Member
Posts: 100
Joined: Wed Jun 11, 2003 1:49 am
Location: Bangalore

Reading parameters dynamically

Post by shiva459 »

Hi
I've designed a sequencer which should read the parameters from os level file.What i did is wrote small pro which reads the values from OS file and assigns to all the jobs in sequencer.But some how it is not able to assign the parameters and taking the default parameters given in the individual jobs.I am providing the job control code for the server job and the pro is highlighted in bold.Please do go through it and correct me where i am going wrong.Any help will be greatly appreciated.
Regards
Shiva
* Tokens were replaced below as follows:
* Id17%%Result1%%1
tonystark622
Premium Member
Premium Member
Posts: 483
Joined: Thu Jun 12, 2003 4:47 pm
Location: St. Louis, Missouri USA

Post by tonystark622 »

Shivakumar
Looks like you're setting the variables p$17$1 and p$17$2 to the literal values of the variable names because of the quotes around the variable names.

Should be:
p$17$1 = ETLEndTime
err$code = DSSetParam(h$17, "ETLEndTS", p$17$1)

and
p$17$2 = ETLStartTime
err$code = DSSetParam(h$17, "ETLStartTS", p$17$2)

Hope this helps,
Tony
shiva459
Premium Member
Premium Member
Posts: 100
Joined: Wed Jun 11, 2003 1:49 am
Location: Bangalore

Post by shiva459 »

Hi Tony
You are absolutely right !.Thats the only mistake i was doing.Now the job is working fine.
Thanks a lot for your help.

Regards
Shiva

Shivakumar
tonystark622
Premium Member
Premium Member
Posts: 483
Joined: Thu Jun 12, 2003 4:47 pm
Location: St. Louis, Missouri USA

Post by tonystark622 »

No problem. Sometimes it's hard to see stuff like that in your own code. Glad I could help.

Tony
Post Reply