DELETE PROCEDURE command: Difference between revisions

From m204wiki
Jump to navigation Jump to search
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&nbsp;204</var> ends any current User Language update unit and begins a non-backoutable update unit. If a <var class="product">Model&nbsp;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&nbsp;204</var> update units, see the <var>Model&nbsp;204 File Manager's Guide.</var>    
When it processes DELETE PROCEDURE, <var class="product">Model&nbsp;204</var> ends any current User Language update unit and begins a non-backoutable update unit. If a <var class="product">Model&nbsp;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&nbsp;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.