RDB/VMS SQL RELEASE — VMS RDB_4.0B
RELEASE -+> statement-name +-> ;
+> parameter -----+
The RELEASE statement releases all resources used by a prepared
statement in dynamic SQL. RELEASE is valid only in precompiled
programs and in module language procedures.
When you prepare an SQL statement for dynamic execution, you
cannot delete any schema definitions (such as constraints,
indexes, or tables) referred to directly or indirectly by the
statement until you release the statment. The RELEASE statement
gives you a way to explicitly release prepared statements. Note
that SQL also implicitly releases dynamic SQL statements in the
following circumstances:
1. After an EXECUTE IMMEDIATE statement
2. When a PREPARE statement refers to an already-prepared
statement name
3. When the same authorization identifier is declared for a
schema referred to in a prepared statement
Additional information available:
statement name
The name of a prepared statement or a statement name assigned in a PREPARE statement.
parameter
You can use an integer parameter instead of coding the statement names. Specifying a parameter lets SQL supply identifiers to programs at run time. A single set of dynamic SQL statements (PREPARE, DESCRIBE, EXECUTE, dynamic DECLARE CURSOR) can handle any number of dynamically executed statements. Should you decide to use parameters, statements that refer to the prepared statement (DESCRIBE, EXECUTE, DECLARE CURSOR) must also use a parameter instead of the explicit statement name.