HI,
I Want to know how to write a routine to find out parameter details for a running job or finish job.
Parameter details for a running job using routine
Moderators: chulett, rschirm, roy
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
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
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
parameter using routines.
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]
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]