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
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.