Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

RDB/VMS SQL RELEASE — VMS SQLdev_2.0

 RELEASE ──> statement-name ──> typebox (;)

 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

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