The SET PROCEDURE command locks a procedure so it can be replaced.
Area: Stored Procedure & 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 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.
