HP NonStop SQL/MP

SQL/MP Statements and Directives
HP NonStop SQL/MP Programming Manual for C—429847-008
3-3
Finding Information
Anywhere in the Program
You can use these directives anywhere in a C program:

WHENEVER directives

SQL SOURCE directive

CONTROL directives
Finding Information
Table 3-1 lists SQL/MP statements and directives you can embed in a C program and
indicates where each statement or directive is documented.
Table 3-1. Summary of SQL/MP Statements and Directives (page 1 of 4)
Statement or Directive Manual * Description
Data Declaration Directives
BEGIN DECLARE SECTION SQLRM
SQLPM/C
Designates the beginning of host variable
declarations.
END DECLARE SECTION SQLRM
SQLPM/C
Designates the end of host variable
declarations.
INCLUDE STRUCTURES SQLRM
SQLPM/C
Specifies the version of SQL structures
generated.
INCLUDE SQLCA SQLRM
SQLPM/C
Generates the SQLCA structure for run-
time status and error information.
INCLUDE SQLDA SQLRM
SQLPM/C
Generates the SQLDA structure to receive
information about input and output
variables for dynamic SQL statements.
INCLUDE SQLSA SQLRM
SQLPM/C
Generates the SQLSA structure to receive
execution statistics about DML or
PREPARE statements.
INVOKE SQLRM
SQLPM/C
Generates a structure description of a table
or view.
*This statement is documented in one or more of these manuals:
SQLRM SQL/MP Reference Manual
SQLPM/C SQL/MP Programming Manual for C