Hi,
While releasing the jobs to production we are releasing them through version control.
Now we wanted to administer all the changes happing in production projects. To achieve this we are using one script which will access DS_AUDIT table to get the Jobname, User modified, Modified time on a particular date. Apart from these we wanted to capture version comments in the report.
(Version comments - Comment added while releasing a job to production through Version control. These comments can be viewed in Job Properties -> General Tab -> Full Description heading.)
Can anybody tell me where these comments are stored and how can I capture them in UNIX script.
Many Thanks
Raghu
Capturing comments added in Version Control.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
Craig,
I am able to find these files in my Version Control Project directory.
I'm able to list these file through Administrator command prompt.
I am also able to get some information if I run the command SELECT * FROM APM.BATCH. When I tried to select only DESC Column (SELECT DESC FROM APM.BATCH) I am getting syntax error.
Can I read these files in UNIX script and in a DataStage job (Universe stage) so that I can take only versioning comments.
I am able to find these files in my Version Control Project directory.
I'm able to list these file through Administrator command prompt.
I am also able to get some information if I run the command SELECT * FROM APM.BATCH. When I tried to select only DESC Column (SELECT DESC FROM APM.BATCH) I am getting syntax error.
Can I read these files in UNIX script and in a DataStage job (Universe stage) so that I can take only versioning comments.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try LIST.DICT APM.BATCH to get the publicly-accessible column names to use in a query.
Beware that DESC is a reserved word in SQL, so would need to be encased in double-quotes if explicitly mentioned in a query.
Beware that DESC is a reserved word in SQL, so would need to be encased in double-quotes if explicitly mentioned in a query.
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.