SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
x
3. Embedded-Only SQL/MX Statements
C++ Examples of BEGIN DECLARE SECTION 3-9
COBOL Examples of BEGIN DECLARE SECTION 3-10
CLOSE Statement 3-11
Considerations for CLOSE 3-11
C Examples of CLOSE 3-12
COBOL Examples of CLOSE 3-13
Compound (BEGIN...END) Statement 3-14
Considerations for Compound Statement 3-14
C Examples of Compound Statement 3-15
DEALLOCATE DESCRIPTOR Statement 3-16
C Examples of DEALLOCATE DESCRIPTOR 3-17
COBOL Examples of DEALLOCATE DESCRIPTOR 3-17
DEALLOCATE PREPARE Statement 3-18
Considerations for DEALLOCATE PREPARE 3-19
C Examples of DEALLOCATE PREPARE 3-19
COBOL Examples of DEALLOCATE PREPARE 3-20
DECLARE CATALOG Declaration 3-21
Considerations for DECLARE CATALOG 3-21
C Examples of DECLARE CATALOG 3-21
COBOL Examples of DECLARE CATALOG 3-21
DECLARE CURSOR Declaration 3-22
Considerations for DECLARE CURSOR 3-24
C Examples of DECLARE CURSOR 3-25
COBOL Examples of DECLARE CURSOR 3-26
Publish/Subscribe Examples of DECLARE CURSOR 3-28
DECLARE MPLOC Declaration 3-29
Considerations for DECLARE MPLOC
3-30
C Examples of DECLARE MPLOC 3-30
COBOL Examples of DECLARE MPLOC 3-31
DECLARE NAMETYPE Declaration
3-32
Considerations for DECLARE NAMETYPE
3-32
C Examples of DECLARE NAMETYPE 3-32
COBOL Examples of DECLARE NAMETYPE
3-32
DECLARE SCHEMA Declaration
3-33
Considerations for DECLARE SCHEMA
3-33
C Examples of DECLARE SCHEMA
3-33
COBOL Examples of DECLARE SCHEMA 3-33
DESCRIBE Statement
3-34
C Examples of DESCRIBE 3-35