Deleting a "Read-Only" Routine

nelab28 · Post by **nelab28** » Mon Oct 10, 2005 9:16 pm

Hi,

We have a set of routines, that were intially imported using the "dsadm" user id, and the project was protected.

One of the routines was modified, and to import this routine did the following:
1) the project was first un-protected,
2) tried to delete the existing routine (but its read-only hence failed in deleting the routine)
3) However, tried to re-import the routine, but encountered "No objects found to import"

What would be the way to delete these read only routines ? (so that i can freshly import the routine).

This is an SOS...Have logged it with the tech support too, but if anyone there has a solution, please shoot it.

Cheers.....

nelab28 · Post by **nelab28** » Mon Oct 10, 2005 10:14 pm

Hi Guys,

Here is the answer :

go to the $DSHOME path
execute . ./dsenv
execute bin/uv.
Then at the command prompt

LOGTO <project name> from the dshome ,
Execute:
UPDATE DS_ROUTINES
SET READONLY = 'NRO'
WHERE DSRID = <routine name>;
Execute LO.

This will then remove the read-only setting, and can then delete the routines.

Cheers !!..

track_star · Post by **track_star** » Tue Oct 11, 2005 2:30 pm

Depending on the version of DS you're using (7.5.x), this is a bug. IBM support can supply you with a patch to correct the issue.

nelab28 · Post by **nelab28** » Thu Oct 13, 2005 3:24 am

I am curious here. I thought it was a good feature to have :
that is when i am importing routines into a protected project, the routines became read-only,
and i had to follow the steps as mentioned to get rid of the read-only, then imported the modified routines.

I am a bit confused here, is it not what it is supposed to do?.