Find a routine whether that routine exist in project or not

[dlkkrao]

Hai Guys,

I have a doubt. I know the routine name, I want to know that,that routine is existed in that particular project or not. I have one solution for that.

Solution:

Login into DS Administrator, go to Projects tab and select your project then go to command option then I tried this one.

SELECT * FROM DS_ROUTINES WHERE DSRID='Routine Name';

Is there any other ways to solve this problem.

Please look into this issue, and send me reply asap.

Thanks,
ROHIT,
(MORE BUILD-UP, LESS BUSINESS)

[ketfos]

Hi,
If you have Metastage, it can help you to find information on an object used in your project.

Ketfos

[talk2shaanc]

Well I think, thatz the simplest and fastest way to find it, if you dont have metastage.
If you are unable to locate the routine; check if its a transform


SELECT * FROM DS_TRANSFORMS WHERE DSRID
LIKE '%Name%';

[ray.wurlod]

Search in DS_AUDIT, which can also tell you if the routine has been deleted.