|
VADELIA |
SADELIA |
WADELIA |
MADELIA |
|
(I/B) (S) |
(B) (S) |
(I/B) (S) |
(I) (S) |
Section for use
All
Syntax
DROP_TABLE TableOrEntityName
Description
This instruction lets you delete a temporary table created using the CREATE_TABLE instruction.
TableOrEntityName can be:
a name from the declarative instruction TEMP_TABLE present in the program,
a logical entity name for which the 'Temporary' box is checked in the LDM.
If the operation is complete, the reserved word *RETURN_CODE is 0, otherwise it is 1. The reserved word *SQLCODE is also updated.
Note: The end of the process also deletes temporary tables.
Example
TEMP_TABLE ORD_TMP *REF(ORDER)
DROP_TABLE ORD_TMP