Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

More Information

RDB/VMS SQL BEGIN_DECLARE — VMS SQLdev_2.0

 EXEC SQL --> BEGIN DECLARE SECTION --> ; -+
 +-----------------------------------------+
 +-+-> host variable declaration--+-+
   +---------<--------------------+ |
 +----------------------------------+
 +-> EXEC SQL --> END DECLARE SECTION --> ;

Additional information available:

More Information

More Information

 BEGIN DECLARE and END DECLARE are optional SQL statements in
 precompiled programs that denote the area in the program where
 parameters referred to by subsequent embedded SQL statements are
 declared.

 You cannot use BEGIN DECLARE or END DECLARE in interactive SQL.  In
 embedded SQL, if you use BEGIN and END DECLARE statements and later
 refer to a parameter in an embedded SQL statement that was not
 declared in the BEGIN-END DECLARE section, SQL generates a warning.

 BEGIN and END DECLARE are provided for compliance with the ANSI SQL
 standard and are optional in VAX SQL.

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