Query on DataStage Repository 7.5
Posted: Mon Feb 27, 2012 11:24 am
Hello,
Note: The following request is on DataStage Versions 7.5.
I need to generate a report to list out the parent categories under "Jobs" of each project on a Server.
The report should have the following columns:
Host Name
Project Name
Parent Category Name (Under Jobs)
Created By User
Created Date
Last Modified By User
Last Modified Date
This report has to be generated for Audit purposes.
I did a simple query on DS Administrator Command line by selecting one of the project:
SELECT CATEGORY FROM DS_JOBS;
The above query is listing out the parent and child categories. But, i only need parent categories along with the above listed columns.
Requirement 1:
Is there a way to write a query to get the information on all the columns listed above Or at least just with Parent Category names at each project level and export it to excel?
Requirement 2:
Is there a script or can we write one to automate listing out parent categories under "Jobs" from all the project on a Server and export the results to Excel?
I had generated a similar report on 8.x versions using Metadata Workbench.
Any help/suggestions are appreciated.
Note: The following request is on DataStage Versions 7.5.
I need to generate a report to list out the parent categories under "Jobs" of each project on a Server.
The report should have the following columns:
Host Name
Project Name
Parent Category Name (Under Jobs)
Created By User
Created Date
Last Modified By User
Last Modified Date
This report has to be generated for Audit purposes.
I did a simple query on DS Administrator Command line by selecting one of the project:
SELECT CATEGORY FROM DS_JOBS;
The above query is listing out the parent and child categories. But, i only need parent categories along with the above listed columns.
Requirement 1:
Is there a way to write a query to get the information on all the columns listed above Or at least just with Parent Category names at each project level and export it to excel?
Requirement 2:
Is there a script or can we write one to automate listing out parent categories under "Jobs" from all the project on a Server and export the results to Excel?
I had generated a similar report on 8.x versions using Metadata Workbench.
Any help/suggestions are appreciated.