Page 1 of 1

DS jobs to be parameterized while exposed as webservi

Posted: Sun Dec 04, 2011 11:15 pm
by adi_2_chaos
Hi All,

I have exposed a datastage job as a webservice using the ISD tool. But there seems to be a doubt with the usage of parameters in the datastage job. Since any job, when deployed as webservice, is continuosly running, and it is initiated by the ISD tool, how can we pass values for the parameters, in case we may have parameterize certain values - ex. database credentials. Can anyone please guide.

Thanks,
Sriram

Posted: Sun Dec 04, 2011 11:28 pm
by ray.wurlod
Parameter values are resolved when the job is started. Therefore, as you surmise, they can not legally be changed once an always-running job is running. You need to get them right when the job is started.

It is also possible through ISD to create "on demand" jobs for infrequent access. These start only when called, so incur any startup overhead for every call. However, they can be designed to set parameter values - probably from an invoking sequence - each time they start.

Posted: Sun Dec 04, 2011 11:50 pm
by chulett
From what I recall, you assign values to the parameters using the ISD tool as well. (in the past, via the RTI console)