Compiled Date in DataStage Repository
Moderators: chulett, rschirm, roy
Compiled Date in DataStage Repository
We are using Parallel jobs and I have been able to get a nice text report using DS_AUDIT. I am trying to find the compiled date that appears in the dsx exports. I am sure that this is probably in this forum but I am having a hard time finding it.
I am just looking for a simple query that lists the job name, when it was imported, who imported it,what category the job belongs to, and when it was compiled. I have all but the compiled date.
I have already tried using the doc tool but it is not very helpful for Parallel jobs.
Any help would be greatly appreciate.
Bren
I am just looking for a simple query that lists the job name, when it was imported, who imported it,what category the job belongs to, and when it was compiled. I have all but the compiled date.
I have already tried using the doc tool but it is not very helpful for Parallel jobs.
Any help would be greatly appreciate.
Bren
etlbets
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The compiled date of a job (or job sequence) is stored in the ROOT record for that job in the DS_JOBOBJECTS table in DataStage internal format. The compiled date of a routine is stored in the DS_ROUTINES table in DataStage internal format.
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.
Hi Ray,
I did
The answereset is
I did
Code: Select all
SELECT * FROM DS_JOBOBJECTS WHERE @ID LIKE '%<JobId>%' AND OBJNAME LIKE 'ROOT%'
There is not Date displayed here. Again, I couldnot find any Date column in DS_JOBOBJECTS table. Am I missing something?Object type........ J
Object record id... 13
Object record name. ROOT
Description........
Regards
Palas
Palas
And that would be because you used SQL against an undocumented internal file. The attributes stored within DS_JOBOBJECTS are not properly defined in the dictionary. You'll want to do a "LIST.DICT DS_JOBOBJECTS" to get what is defined, then explicitly name the columns in your SQL. Anything else you may have interest in will have to come thru experimentation to find. I suggest a raw text dump of the root record using "CT DS_JOBOBJECTS J\13\ROOT".
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Compiled date is one of the undocumented columns. It is not accessible as a column name. You need to work out which field contains it, and use an EVAL construct to access it.
Actually, I just took a look at DS_JOBOBJECTS and can't find the compilation date. I may need to get back to you on that.
Actually, I just took a look at DS_JOBOBJECTS and can't find the compilation date. I may need to get back to you on that.
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.
Did you find the compile date by any chance.ray.wurlod wrote:Compiled date is one of the undocumented columns. It is not accessible as a column name. You need to work out which field contains it, and use an EVAL construct to access it.
Actually, I just took a look at DS_JOBOBJECTS and can't find the compilation date. I may need to get back to you on that.
Thanks
etlbets
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: