SQL/MX 2.x Reference Manual (H06.04+)

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-2
For more information on how to embed SQL/MX statements in C or COBOL programs,
see the SQL/MX Programming Manual for C and COBOL.
DECLARE SCHEMA Declaration on
page 3-32
Sets default schema for unqualified object
names in static SQL statements within a
compilation unit.
DESCRIBE Statement
on page 3-33 Uses an SQLDA to return descriptions of output
variables (usually SELECT columns) and input
parameters for a prepared statement.
END DECLARE SECTION Declaration
on
page 3-36
Designates the end of a Declare Section.
EXEC SQL Directive
on page 3-37 Begins an embedded SQL statement or
declaration.
EXECUTE IMMEDIATE Statement
on
page 3-38
Prepares (compiles) and executes a dynamic
SQL statement.
FETCH Statement
on page 3-39 Retrieves a row using a cursor.
GET DESCRIPTOR Statement
on
page 3-45
Retrieves information from an SQLDA.
GET DIAGNOSTICS Statement
on
page 3-54
Returns diagnostic information about the most
recently executed SQL statement.
IF Statement
on page 3-60 Compound statement that provides conditional
execution based on the truth value of a
conditional expression.
INVOKE Directive on page 3-63 Generates a structure description of a table or
view.
MODULE Directive
on page 3-69 Specifies the name of an embedded SQL
module for the preprocessor.
OPEN Statement
on page 3-71 Opens a cursor.
SET (Assignment) Statement
on
page 3-75
Assigns a value to a host variable so that
subsequent statements in the containing
compound statement can reference and use the
value of that host variable.
SET DESCRIPTOR Statement
on
page 3-77
Modifies information in an SQLDA.
WHENEVER Declaration
on page 3-85 Generates code that checks SQL statement
execution for errors and the end no-data
condition and specifies an action to take.
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL