DELETE PROCEDURE command: Difference between revisions
m (Automatically generated page update) |
|||
| Line 48: | Line 48: | ||
<p>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.</p> | <p>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.</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> | <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 | 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: General user commands]] | [[Category: General user commands]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Revision as of 20:41, 6 August 2015
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.