SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xx
3. Embedded-Only SQL/MX Statements
DECLARE SCHEMA Declaration 3-33
Considerations for DECLARE SCHEMA 3-33
Scope of 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
COBOL Examples of DESCRIBE 3-36
END DECLARE SECTION Declaration 3-37
C Examples of END DECLARE SECTION 3-37
C++ Examples of END DECLARE SECTION 3-37
COBOL Examples of END DECLARE SECTION 3-37
EXEC SQL Directive 3-38
Considerations for EXEC SQL 3-38
Using Host Language Comments 3-38
Examples of EXEC SQL 3-38
EXECUTE IMMEDIATE Statement 3-39
Considerations for EXECUTE IMMEDIATE 3-39
Parameters 3-39
C Examples of EXECUTE IMMEDIATE 3-39
COBOL Examples of EXECUTE IMMEDIATE 3-39
FETCH Statement 3-40
Considerations for FETCH 3-42
Authorization Requirements 3-42
Ordering Fetched Rows 3-42
Too Many Values or Too Many Variables 3-42
Using Extended Dynamic Cursors
3-42
Status Information 3-42
C Examples of FETCH 3-43
COBOL Examples of FETCH
3-44
GET DESCRIPTOR Statement
3-46
SQL Item Descriptor Area of GET DESCRIPTOR 3-48
SQL Descriptor Area Data Type Declarations of GET DESCRIPTOR
3-51
Considerations for GET DESCRIPTOR
3-53
Processing Items in a Descriptor Area
3-53
Version Differences for TYPE and TYPE_FS
3-53
C Examples of GET DESCRIPTOR 3-53
COBOL Examples of GET DESCRIPTOR
3-54
GET DIAGNOSTICS Statement 3-55