Hello All,
I have a set of routines which are in read only mode. I want to delete or over write them.
1. The simplest: I exported the modifed routine to over write the existing one. But could not: Because I was not able to over write a read only routine.
2. I failed in deleting the read only routines.
3. I exported the dsx of routines. Updated the "Readonly" value from 1 to 0 and then tried re-exporting it. Could not do it: reason same as point 1.
4. I could see from the post's that I will be able to make the routine in editable form If I execute the below command:
UPDATE DS_ROUTINES SET READONLY = 'NRO' WHERE DSRID = routinename;
where routinename is the name of a routine under my folder, RoutineFolder.
I executed this in administrator and it was not working. Might be my mistake.
Would some one be able to help me with deleting or over writing the routine?
To Delete read only routines
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 33
- Joined: Sat Jul 02, 2005 2:27 am
- Location: Bangalore
To Delete read only routines
warm regards,
Ajith GK
Ajith GK
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It would have been useful had you posted the error message generated rather than "it was not working".
Regular SQL rules apply even in DataStage/SQL. The routinename is a string (VarChar) data type, and so the value in the WHERE clause needs to be surrounded with single quote characters.
Regular SQL rules apply even in DataStage/SQL. The routinename is a string (VarChar) data type, and so the value in the WHERE clause needs to be surrounded with single quote characters.
Code: Select all
UPDATE DS_ROUTINES SET READONLY = 'NRO' WHERE DSRID = 'routinename';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 33
- Joined: Sat Jul 02, 2005 2:27 am
- Location: Bangalore