DELETE PROCEDURE command: Difference between revisions
No edit summary |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 49: | Line 49: | ||
<p class="note"><b>Note:</b> Once the PROCEDURE command with an ALIAS option is issued, the alias is created. Deleting the procedure does <i>not</i> delete the alias. Only the DEASSIGN command removes the alias. </p> | <p class="note"><b>Note:</b> Once the PROCEDURE command with an ALIAS option is issued, the alias is created. Deleting the procedure does <i>not</i> delete the alias. Only the DEASSIGN command removes the alias. </p> | ||
When it processes DELETE PROCEDURE, <var class="product">Model 204</var> ends any current User Language update unit and begins a non-backoutable update unit. If a <var class="product">Model 204</var> command non-backoutable update unit is in progress, DELETE PROCEDURE is included in that update unit. For more information about <var class="product">Model 204</var> update units, see [[File integrity and recovery#Update units and transactions|Update units and transactions]]. | When it processes DELETE PROCEDURE, <var class="product">Model 204</var> ends any current User Language update unit and begins a non-backoutable update unit. If a <var class="product">Model 204</var> command non-backoutable update unit is in progress, DELETE PROCEDURE is included in that update unit. For more information about <var class="product">Model 204</var> update units, see [[File integrity and recovery#Update units and transactions|Update units and transactions]]. | ||
[[Category: | [[Category: User commands]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Latest revision as of 16:18, 22 March 2017
Summary
- Privileges
- Any user
- Function
- Deletes a procedure
Syntax
DELETE [[PROCEDURE] {procnumber | procname}]
Where:
| procnumber | is the number of an existing temporary procedure; it can be zero or a negative number. |
|---|---|
| procname | is the name of an existing procedure.
If neither procnumber nor procname is specified, temporary procedure 0 is deleted. |
Syntax notes
If procname includes Model 204 special characters, enclose it in single quotes:
DELETE [PROC] 'procname'
Example
DELETE ACCOUNT DELETE PROC -2 DELETE
Usage notes
The DELETE PROCEDURE command deletes procedures that you have defined.
-
Permanent procedure are stored by Model 204 until they are deleted or until the file in which they are stored is reinitialized.
-
Temporary procedures are saved in a system scratch file only during the current terminal session and are deleted when you log out.
When a procedure is deleted, Model 204 recovers the space it occupied in the procedure file. The procedure file is the file specified in the PROCEDURE command, or, if a file was not specified, the file that was open at the time the PROCEDURE command was issued.
The DELETE PROCEDURE command does not execute when multiple procedure files have been specified for a group. In this case, DELETE PROCEDURE must be used in a file context.
Note: Once the PROCEDURE command with an ALIAS option is issued, the alias is created. Deleting the procedure does not delete the alias. Only the DEASSIGN command removes the alias.
When it processes DELETE PROCEDURE, Model 204 ends any current User Language update unit and begins a non-backoutable update unit. If a Model 204 command non-backoutable update unit is in progress, DELETE PROCEDURE is included in that update unit. For more information about Model 204 update units, see Update units and transactions.