DSXchange

Thanks for reading. How to find all jobs that use database stage as reference link. Looking for a search of somekind. Any help is greatly appreciated.

If you go to your designer, navigate the repository to

Stages Types -> Parallel -> Database -> {your stage type}

then right-mouse-click and "find where used"

you will get a list of jobs where that stage is used.

Thanks for your response...

but we need to know where db2 stages are used as 'reference links' and not where the db2 stage is used anywhere in a job. So we are looking for a specific scenario where the db2 stage is used...in this case used as a reference link. Any help is greatly appreciated. Thanks.

I can't think of a way to get this with a quick click method.

With a small DS/BASIC routine you could loop through all jobs, and in each job loop through all links, and then find those which have a passive stage at the source end and print those out where the stage type is db2.

Thanks for the reply. We'll try this.