Data Manipulation Language Statements › DELETE TABLE (DC/UCF)

DELETE TABLE (DC/UCF)

The DELETE TABLE statement notifies the system that the issuing task has finished using a table that has been loaded into the program pool by using the LOAD TABLE function. DELETE TABLE does not physically delete reusable tables from the program pool; rather, it decrements the in-use count maintained by the DC/UCF system. An in-use count of 0 signals to the system that the space occupied by the table can be reused.

Syntax

►►─── DELETE TABLE FROM (table-location-pointer); ────────────────────────────►◄

Parameter

table-location-pointer

Specifies a table location where the in-use count maintained by the system is to be decremented. Table-location-pointer specifies the variable-storage pointer location that was set when the table was loaded via a LOAD TABLE request.

Example

The following example releases a previously loaded table from the location in variable storage identified by RATE_TABLE_PTR:

DELETE TABLE FROM (RATE_TABLE_PTR);

Status Codes

Upon completion of the DELETE TABLE function, the ERROR_STATUS field in the IDMS DC communications block indicates the outcome of the operation: