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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxi
3. Embedded-Only SQL/MX Statements
Statement Items of GET DIAGNOSTICS 3-57
Condition Items of GET DIAGNOSTICS 3-57
Considerations for GET DIAGNOSTICS 3-59
Processing Condition Items in the Diagnostics Area 3-59
Writing a Log of Exception Conditions 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
SQL Statements in the List 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
Preserving or Overriding the INVOKE Directive 3-66
Using DEFINE Names in the Windows NT Environment 3-66
SYSKEY Column 3-66
Authorization Requirements 3-66
Using INVOKE in a C Program 3-67
C Examples of INVOKE 3-67
COBOL Examples of INVOKE 3-69
MODULE Directive 3-70
Considerations for MODULE 3-70
Directive Used by the Preprocessor 3-70
Automatic Generation of Module Names 3-71
C Examples of MODULE 3-71
COBOL Examples of MODULE
3-71
OPEN Statement 3-72
Considerations for OPEN 3-73
Establishing the Result Table
3-73
Authorization Requirements
3-73
Declaring Host Variables 3-73
Using Extended Dynamic Cursors
3-73
USING Clause
3-74
C Examples of OPEN
3-74
COBOL Examples of OPEN
3-75
SET (Assignment) Statement 3-76
C Examples of Assignment Statement
3-77
SET DESCRIPTOR Statement 3-78