DECLARE SECTION

Identifies declaration of host variables used in SQL statements.

declare_section.png

 

Usage

Embedded.

Description

Host variables declared between the BEGIN DECLARE SECTION and END DECLARE SECTION statements are declared for both the host language compiler and the SQL compiler. Host variables used in SQL statements must be declared in an SQL DECLARE SECTION.

Notes

Host variables declared in the SQL DECLARE SECTION must be elementary data items or pointers to character strings. They may not be declared as part of a record or structure.

The rules for placing the DECLARE SECTION in the host program code and for declaring variables within the SECTION follow the host language syntax.

Language-specific issues are discussed in the Mimer SQL Programmer's Manual, Host Language Dependent Aspects.

SQL statements may not be placed within the SQL DECLARE SECTION.

BEGIN DECLARE SECTION and END DECLARE SECTION are two separate SQL statements, each of which must be preceded by EXEC SQL and followed by the (language-specific) statement terminator.

Example

The following example, in C, shows the correct usage of both statements:

exec sql BEGIN DECLARE SECTION;

   char SQLSTATE[6];

   char usernm[129], passwd[19];

   NVARCHAR tablenm[129];

exec sql END DECLARE SECTION;

Standard Compliance

Standard

Compliance

Comments

SQL-2016

Core

Fully compliant.