I am using DS 7.x.x version, I have 3000 jobs and most of the jobs are with the transformation ( medium and complex) and I would like to get the DERIVATION part that is used in all 3000 jobs at one go.
Is there any command that is available that can be triggered from ADMIN / from ds.tools or from SDK / of from utilities?
Please let me know.
Thanks,
Basheer
Datastage Derivations
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
You could create a script that loops through the output of dsjob -ljobs for the project and, for each, uses dsjob to generate the job report.
Sure this contains more information than the derivations but, at least, they're in there. If you generate an XML format report you can use any XML parser (even a DataStage job) to isolate the derivations.
You could create a script that loops through the output of dsjob -ljobs for the project and, for each, uses dsjob to generate the job report.
Sure this contains more information than the derivations but, at least, they're in there. If you generate an XML format report you can use any XML parser (even a DataStage job) to isolate the derivations.
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.