Hi Experts,
I can see the below code used in a IBM utility which when setup at the administrator console, we can set job level auto purge for all the jobs in a project at once.
" WRITE DRSET:@FM:DAYS:@FM:RUNS ON LOGFILE,"//PURGE.SETTINGS" ELSE STOP 'WRITE ERROR'"
Can anybody know more about this code? I want to modify this code so that I can revoke all the job level auto purge at once using this code.
Anybody makes any sense of this code?
Thanks in advance!
Need to revoke job level auto pourge for multiple jobs at 1s
Moderators: chulett, rschirm, roy
Search is your friend, found around 30 other posts on this topic or a variation thereof. For example, this should help:
viewtopic.php?t=106690
viewtopic.php?t=106690
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The code snippet you posted changes the purge settings for one job's log file only. To change all jobs you would need to run the same code against every job's log.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 136
- Joined: Wed May 07, 2008 11:26 am
- Location: Sydney, Australia
- Contact:
Yes Ray,
Exactly, this code changes the auto purge setting of the job. So my query here is
1) I want to understant what this code is.. is it c++ of what?
2) I want to know how can I change this code so that the new code when run on a perticular job, removes the joblevel auto purge and hence project level auto purge becomes active.
In short I want the meaning and use of DRSET, @FM PURGE.SETTING etc.
Please can you help me disect this kind of code so that I can try simple coding myself as mentioned earlier?
Exactly, this code changes the auto purge setting of the job. So my query here is
1) I want to understant what this code is.. is it c++ of what?
2) I want to know how can I change this code so that the new code when run on a perticular job, removes the joblevel auto purge and hence project level auto purge becomes active.
In short I want the meaning and use of DRSET, @FM PURGE.SETTING etc.
Please can you help me disect this kind of code so that I can try simple coding myself as mentioned earlier?
Vinay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DRSET is a variable that, presumably, had its value set earlier in your routine.
@FM is a system variable that contains the value of "field mark", the top-level field delimiter in records in hashed files (the local job logs are hashed files).
"//PURGE.SETTINGS" is the record ID of the record in the job log that contains the purge settings.
Why not consult the DataStage BASIC manual or, if you want a learning experience, check out the "Programming with DataStage BASIC" DVD available from the DSXchange Learning Center (www.dsxchange.net)?
@FM is a system variable that contains the value of "field mark", the top-level field delimiter in records in hashed files (the local job logs are hashed files).
"//PURGE.SETTINGS" is the record ID of the record in the job log that contains the purge settings.
Why not consult the DataStage BASIC manual or, if you want a learning experience, check out the "Programming with DataStage BASIC" DVD available from the DSXchange Learning Center (www.dsxchange.net)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: