Search code examples
datastage

Automated way to see Queries in all Oracle Connectors of all jobs in datastage


Is there a way to see all the queries that are there in my Oracle COnnector stages of my datastage project? I am using DS 11.3.


Solution

  • No not natively. You could export your project and parse the export for all of the SQL staments (this could be done by a DataStage job of cause) or you might be able to query it if you have IGC Information Governance Catalog) in place.