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.....
Deleting a "Read-Only" Routine
Moderators: chulett, rschirm, roy
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 !!..
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 !!..
-
- Participant
- Posts: 60
- Joined: Sat Jan 24, 2004 12:52 pm
- Location: Mount Carmel, IL
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?.
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?.