Stored Procedures & Triggers
Options
ON
Enables a lock
OFF
Disables a lock set by SET PROCEDURE or GET LOCK.
About the SET PROCEDURE Command
The SET PROCEDURE command locks a procedure so it can be replaced. It works like the GET LOCK command without retrieving the stored procedure into an ASCII file. ON sets the lock; OFF releases the lock placed by the SET PROCEDURE or the GET command.
When a procedure is locked, only the user placing the lock can replace the procedure or remove the lock. The NAME setting is used for identification of the user.
