Page 1 of 1
Delete custom routine exported by mistake as read-only
Posted: Mon Feb 18, 2008 3:29 pm
by yserrano
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]
Posted: Mon Feb 18, 2008 3:31 pm
by ray.wurlod
Can't you simply delete it using Designer?
Posted: Mon Feb 18, 2008 5:02 pm
by deanwalker
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? ...
Posted: Tue Feb 19, 2008 5:01 am
by asitagrawal
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
Posted: Tue Feb 19, 2008 11:21 am
by yserrano
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]
Posted: Tue Jun 23, 2009 6:18 am
by virgenie
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.
Posted: Fri Sep 11, 2009 1:02 am
by harish_s_ampeo
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.
Posted: Fri Sep 11, 2009 2:09 am
by jaysheel
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 ?