SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Reference Manual—640322-001
x
3. Embedded-Only SQL/MX
Statements (continued)
3. Embedded-Only SQL/MX Statements (continued)
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
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
Examples of EXEC SQL 3-38
EXECUTE IMMEDIATE Statement 3-39
Considerations for EXECUTE IMMEDIATE 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
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
C Examples of GET DESCRIPTOR 3-53
COBOL Examples of GET DESCRIPTOR 3-54
GET DIAGNOSTICS Statement 3-55
Statement Items of GET DIAGNOSTICS 3-57
Condition Items of GET DIAGNOSTICS 3-57
Considerations for GET DIAGNOSTICS 3-59
C Examples of GET DIAGNOSTICS 3-59
COBOL Examples of GET DIAGNOSTICS 3-60
IF Statement 3-61