Page 1 of 1

Quick Find doesn't find stage names

Posted: Wed Jun 11, 2014 10:44 am
by cppwiz
I need to find jobs that use certain tables, but the table definitions are not imported into the repository. Instead, each table is coded in a Dynamic RDBMS stage with the stage name the same as the table name.

The problem is that neither Quick Find or Advanced Find is finding the jobs with the stage names even if I use wildcards around the name. When I do a manual hunt for the stages, I can see the stage name is set correctly in the Property Browser.

The easy solution would be to export the entire repository to a DSX file and search it outside of DS Designer, but alas the import and export security has been restricted.

Are DS_JOBS and DS_JOBOBJECTS queries my only option or is there some other way to find the stage names?

Posted: Wed Jun 11, 2014 11:50 am
by vamsi.4a6
I believe MetadataworkBench Tool from IBM will suit your requirement.

Posted: Wed Jun 11, 2014 4:48 pm
by ray.wurlod
Neither stages nor links are independent repository objects, which is why you can't select them and why you can't search for them.

As noted, Metadata Workbench is the preferred tool for searching for named components.