RDB/VMS SQL RELEASE — VMS RDB_4.1A
RELEASE -+> statement-name ----------+-> ;
+> 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.