Delete custom routine exported by mistake as read-only

yserrano · Post by **yserrano** » Mon Feb 18, 2008 3:29 pm

Hello, I am trying to accomplish what is described in this Resolved Topic, but, I am using DataStage V8 and the the query:

UPDATE DS_ROUTINES SET READONLY = 'NRO' WHERE DSRID = 'routinename'

works only for those routines which come with the base product. My custom routine is not in that table.

I will appreciate your help pointing the right table or correct method to delete the routine.

Best regards,

Yonny Serrano[/url]

ray.wurlod · Post by **ray.wurlod** » Mon Feb 18, 2008 3:31 pm

Can't you simply delete it using Designer?

deanwalker · Post by **deanwalker** » Mon Feb 18, 2008 5:02 pm

If it has been imported as ReadOnly, this flag is set in the new repository and the Designer will not delete a readonly Routine. It will not appear in DS_ROUTINES if it has not been compiled yet, and if it has been compiled then setting NRO in the old repository will have no effect. You will need to delete it from the new repository, and you will need help from your supplier for this.

ray.wurlod wrote:Can't you simply delete it using Designer? ...

asitagrawal · Post by **asitagrawal** » Tue Feb 19, 2008 5:01 am

If you still have the .dsx file (i.e the exported file containing the routines)...
then search for ReadOnly phrase...

Code: Select all

.
.
OLEType "CRoutine"
Readonly "0"
Category "EPM89_Routines\\Generic"
.
.

Change the value "0" to "1" for ReadOnly prameter... and import again..
You must change this for the applicable objects.. I assume that that you have exported only the routines.

Remember...this is not a very good approach...but it has helped me many times...

HTH

yserrano · Post by **yserrano** » Tue Feb 19, 2008 11:21 am

Change the value "0" to "1" for ReadOnly prameter... and import again..

I can't, Designer does not let me overwrite a ReadOnly routine.

It will not appear in DS_ROUTINES if it has not been compiled yet

It is compiled but still it does not appear there.
[/quote]

virgenie · Post by **virgenie** » Tue Jun 23, 2009 6:18 am

yserrano wrote:
Change the value "0" to "1" for ReadOnly prameter... and import again..
I can't, Designer does not let me overwrite a ReadOnly routine.

It will not appear in DS_ROUTINES if it has not been compiled yet
It is compiled but still it does not appear there.

i just had this problem in V8.1. I deleted it in the developer because i am administrator. And then, i just imported again my routine with the value ReadOnly set as "0" in my dsx.

harish_s_ampeo · Post by **harish_s_ampeo** » Fri Sep 11, 2009 1:02 am

I have a similar problem.Am using Datastage Server V8.0 . Even if I login as admin, am not able to delete the routine from designer.

jaysheel · Post by **jaysheel** » Fri Sep 11, 2009 2:09 am

I have the similar problem. And to add more the routine wont show up in the transformer derivation window. I can't delete it, rename it or overwrite it using another .dsx file. What I did is simply created another routine and replaced all my jobs which were using the old routine. Anyone has a solution for this ?