SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Embedded SQL Statements
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
2-6
Embedded SQL Declarations and Statements
time as an embedded SQL statement. The member function references host variables
that are class data members.
Embedded SQL Declarations and Statements
These tables list all the SQL declarations and statements that you can embed in a 3GL
program:
•
Table 2-1 on page 2-6 describes the MODULE directive, which you should place at
the beginning of a 3GL program.
•
Table 2-2 on page 2-6 summarizes the embedded SQL statements that you can
use only in an SQL Declare Section of a 3GL program.
•
Table 2-3 on page 2-7 summarizes the nonexecutable SQL statements that affect
other static SQL statements embedded in a 3GL program.
•
Table 2-4 on page 2-8 summarizes the executable SQL statements you can embed
in a 3GL program.
For detailed syntax, use considerations, and examples of the embedded SQL
discussed in this manual, see the SQL/MX Reference Manual.
Table 2-1. MODULE Directive
Statement Description
MODULE Specifies module name to be used for
module file.
Table 2-2. Embedded SQL Statements in SQL Declare Section
Statement Description
BEGIN DECLARE SECTION Designates the beginning of a Declare
Section for host variable declarations.
END DECLARE SECTION Designates the end of a Declare Section.
INVOKE* Generates a structure description of a table
or view.
* Indicates the statement is an SQL/MX extension.