How to delete IsMultiInstance?

[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

[loveojha2]

First make it modifyable using

Code: Select all

UPDATE DS_ROUTINES SET READONLY = 'NRO' WHERE READONLY = 'RO' 
and DSRID = 'routinename'

then delete it.

[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

[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

Code: Select all

LIST.DICT DS_ROUTINES

you will be able to see the complete (public part only, not entire structure) of this Hashed File.

[Prashantoncyber]

thanks loveojha2

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