Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

statement name

parameter

RDB/VMS SQL RELEASE — VMS RDB_4.1A

 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 nameparameter

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.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026