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

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual663850-001
xi
3. Embedded-Only SQL/MX Statements
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
Considerations for IF Statement
3-62
C Example of IF Statement
3-62
COBOL Example of IF Statement 3-63
INVOKE Directive
3-64
Considerations for INVOKE
3-66
C Examples of INVOKE
3-67
COBOL Examples of INVOKE
3-69
MODULE Directive 3-70
Considerations for MODULE
3-70
C Examples of MODULE 3-71