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

HP NonStop SQL/MX Reference Manual—540440-003
3-1
3
Embedded-Only SQL/MX Statements
This section describes the syntax and semantics of NonStop SQL/MX statements that
you can embed only in programs written in C, C++, COBOL, or Java.
In NonStop SQL/MX Release 2.x, mixing embedded SQL calls to NonStop SQL/MP
and NonStop SQL/MX from the same application process is not supported.
You cannot run these statements, or specific forms of these statements, in MXCI:
ALLOCATE CURSOR Statement on
page 3-3
Allocates an SQL cursor.
ALLOCATE DESCRIPTOR Statement
on
page 3-6
Allocates an input or output SQL descriptor area
(SQLDA).
BEGIN DECLARE SECTION Declaration
on page 3-9
Designates the beginning of a Declare Section
for host variable declarations.
CLOSE Statement
on page 3-11 Closes a cursor.
Compound (BEGIN...END) Statement
on
page 3-14
Groups embedded SQL statements together into
a single data access request to reduce the
number of times the client has to wait for the
server.
DEALLOCATE DESCRIPTOR Statement
on page 3-16
Deallocates an SQLDA.
DEALLOCATE PREPARE Statement
on
page 3-18
Deallocates a prepared statement and returns
the system resources used by the statement;
permits reuse of the statement name.
DECLARE CATALOG Declaration
on
page 3-21
Sets default catalog for unqualified schema
names in static SQL statements within a
compilation unit.
DECLARE CURSOR Declaration
on
page 3-22
Specifies a static cursor in a host program and
associates the name of the cursor with a query
expression that specifies the rows to be
retrieved by using the cursor. Also specifies a
dynamic cursor.
DECLARE MPLOC Declaration
on
page 3-28
Sets a default NonStop operating system
volume and subvolume for unqualified physical
object names in static SQL statements within a
compilation unit.
DECLARE NAMETYPE Declaration
on
page 3-31
Sets default NAMETYPE attribute value to ANSI
or NSK for static statements within a compilation
unit.
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL
C/COBOL