Page 1 of 1
How to delete IsMultiInstance?
Posted: Tue Nov 14, 2006 11:43 pm
by Prashantoncyber
I am unable to delete Ray's routine as it is giving this error.
Record IsMultiInstance in file DS_ROUTINES is read-only and cannot be deleted
I need to clean up enviroment.
I am sure Ray can definately advice me.
thank
Posted: Tue Nov 14, 2006 11:50 pm
by loveojha2
First make it modifyable using
Code: Select all
UPDATE DS_ROUTINES SET READONLY = 'NRO' WHERE READONLY = 'RO'
and DSRID = 'routinename'
then delete it.
Posted: Wed Nov 15, 2006 1:28 am
by Prashantoncyber
First make it modifyable using
Code:
UPDATE DS_ROUTINES SET READONLY = 'NRO' WHERE READONLY = 'RO'
and DSRID = 'routinename'
then delete it.
Looks very powerful as deleted Ray's Routine.
BTW loveojha2, can you tell (tips) how do you conclude/frame this commands?
thanks
Posted: Wed Nov 15, 2006 1:45 am
by loveojha2
BTW loveojha2, can you tell (tips) how do you conclude/frame this commands?
I learnt it on this site only, and at the same time, DS_ROUTINES stores info about name, desc, etc of the routines and it is too a Hashed File, moreover by issuing
you will be able to see the complete (public part only, not entire structure) of this Hashed File.
Posted: Wed Nov 15, 2006 1:52 am
by Prashantoncyber
thanks loveojha2
Posted: Wed Nov 15, 2006 8:48 am
by ray.wurlod
I must hasten to add that it is not my routine itself that is giving the error! It is the security setting on the routine in its table.