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]