Identifies declaration of host variables used in SQL statements.
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.
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, Appendix A, 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.
The following example, in C, shows the correct usage of both statements:exec sql BEGIN DECLARE SECTION; char SQLSTATE; char usernm, passwd; NVARCHAR tablenm; exec sql END DECLARE SECTION;
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40