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? ...
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...
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.
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 ?