RDB/VMS SQL RELEASE — VMS RDB_4.1_M
RELEASE ─┬> statement-name ──────────┬─> typebox (;) └> statement-id-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 database definitions (such as constraints, indexes, or tables) referred to directly or indirectly by the statement until you release the statement. 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 alias is declared for a database 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.