I am not an ADMIN which should be quite obvious by ny nick. How do I find the details (Created by, Date) for DataStage objects like HashFiles, Routines and Table Defs.
Thanks in advance.
DSAdmin Question
Moderators: chulett, rschirm, roy
-
datastagedummy
- Participant
- Posts: 56
- Joined: Thu Feb 13, 2003 6:08 pm
- Location: USA
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use the Manager client, and choose View > Details to get the date/time modified for any object in the Repository.
Created by is in a table in the project called DS_AUDIT, but this is not exposed in any client. You can still use the Administrator client, Command Window, to execute a query. For example:
SELECT * FROM DS_AUDIT;
To discover the column names in the DS_AUDIT table, execute the following (non-SQL) command:
LIST.DICT DS_AUDIT
This will allow you to construct appropriate WHERE clauses to restrict the report. Note, also, that the object type is enumerated (from memory jobs are 2, routines 4).
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Created by is in a table in the project called DS_AUDIT, but this is not exposed in any client. You can still use the Administrator client, Command Window, to execute a query. For example:
SELECT * FROM DS_AUDIT;
To discover the column names in the DS_AUDIT table, execute the following (non-SQL) command:
LIST.DICT DS_AUDIT
This will allow you to construct appropriate WHERE clauses to restrict the report. Note, also, that the object type is enumerated (from memory jobs are 2, routines 4).
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518