Page 1 of 1

Parameter details for a running job using routine

Posted: Sat Dec 02, 2006 6:34 am
by roshan
HI,

I Want to know how to write a routine to find out parameter details for a running job or finish job.

Posted: Sat Dec 02, 2006 7:05 am
by ArndW
The routine that you are going to write will contain a couple of key calls that you can look up in the DataStage BASIC Programmer's guide, namely:

DSAttachJob() - to attach to the job you wish to get information about
DSGetParamInfo() - to get the parameter information for that job run
DSDetachJob() - to close up the attached job

parameter using routines.

Posted: Mon Dec 04, 2006 12:15 am
by roshan
Thanks ArndW,

I tried and found successful.
But my problem is, i want to extract info (parameters ) for all the jobs , present in the repository ( RTLOG ) for whom parameters are varies with the job.




[quote="ArndW"]The routine that you are going to write will contain a couple of key calls that you can look up in the [u][i]DataStage BASIC Programmer's guide[/i][/u], namely:

[b]DSAttachJob()[/b] - to attach to the job you wish to get information about
[b]DSGetParamInfo()[/b] - to get the parameter information for that job run
[b]DSDetachJob()[/b] - to close up the attached job[/quote]