I have to compile a list of all the jobs and the transformations in the job is there any simple way of achieving this ?
DS_JOBS will give me the names of all the jobs in the PROJECT but how do I get the transformations in the job ?
Any IDEA/thoughts
Thanks
DataStage Job & Transformation List
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 56
- Joined: Thu Feb 13, 2003 6:08 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is the kind of task that the database associated with the Documentation Tool is geared towards.
You can use the default (doc_tool.mdb) and generate your own queries using Microsoft Access.
Or you can use your database of choice, which is accessed via ODBC from your Manager client. Scripts for creating the required tables can be found with your DataStage client software, in the "Documentation Tool" folder. Set the DSN in the Options tab of the Documentation Tool dialog before exporting metadata.
You can use the default (doc_tool.mdb) and generate your own queries using Microsoft Access.
Or you can use your database of choice, which is accessed via ODBC from your Manager client. Scripts for creating the required tables can be found with your DataStage client software, in the "Documentation Tool" folder. Set the DSN in the Options tab of the Documentation Tool dialog before exporting metadata.
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: 56
- Joined: Thu Feb 13, 2003 6:08 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: