protected - routine
Moderators: chulett, rschirm, roy
protected - routine
Is there a way we could set a routine (only one routine) from not being accessed by anyone other than dsadm.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can not protect the source code of the Routine, since it is a row in the Repository table DS_ROUTINES. You can make it read-only (to all) via the READONLY column. But this would not prevent anyone from inspecting the code.
If you really want to hide a routine, then you have to resort to a mechanism described in the DataStage BASIC manual but not often implemented. And you would not be able to edit the routine code using the Manager or Designer clients without reversing the mechanism.
This technique involves you creating and compiling the Routine as usual, but then moving the source code from DS_ROUTINES to somewhere more secure, probably a directory. For example, to put the routine source code for MyRoutine into the VOCLIB hashed file:
If you really want to hide a routine, then you have to resort to a mechanism described in the DataStage BASIC manual but not often implemented. And you would not be able to edit the routine code using the Manager or Designer clients without reversing the mechanism.
This technique involves you creating and compiling the Routine as usual, but then moving the source code from DS_ROUTINES to somewhere more secure, probably a directory. For example, to put the routine source code for MyRoutine into the VOCLIB hashed file:
Code: Select all
COPY FROM DS_ROUTINES TO VOCLIB MyRoutine DELETING
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.