SQL/MX Programming Manual for C and COBOL (H06.10+, J06.03+)

Contents
HP NonStop SQL/MX Programming Manual for C and COBOL—544617-003
xiii
Examples (continued)
Examples (continued)
Example A-5. Using SQL Descriptor Areas Without DESCRIBE A-12
Example A-6. Using a Dynamic SQL Cursor A-15
Example A-7. Using a Dynamic SQL Cursor With Descriptor Areas A-18
Example A-8. Dynamic SQL Rowsets A-26
Example A-9. DDL for KANJI and KSC4501 Table Columns A-28
Example A-10. Using SQL Descriptor Areas to Select SQL/MP KANJI and KSC5601
Data A-30
Example A-11. Using SQL Descriptors to Select UCS2 Data A-35
Example B-1. Using TMF to Ensure Data Consistency B-1
Example C-1. Using a Static SQL Cursor C-1
Example C-2. Using TMF to Ensure Data Consistency C-4
Example C-3. Using Argument Lists in Dynamic SQL C-6
Example C-4. Using Descriptor Areas With DESCRIBE C-9
Example C-5. Using a Dynamic SQL Cursor C-13
Figures
Figure 6-1. Using a Static SQL Cursor in a C Program 6-2
Figure 6-2. Using a Static SQL Cursor in a COBOL Program 6-3
Figure 9-1. Using Dynamic SQL in a C Program 9-3
Figure 9-2. Using Dynamic SQL in a COBOL Program 9-4
Figure 10-1. Using SQL Descriptor Areas in a C Program 10-12
Figure 10-2. Using SQL Descriptor Areas in a COBOL Program 10-13
Figure 11-1. Using a Dynamic SQL Cursor in a C Program 11-2
Figure 11-2. Using a Dynamic SQL Cursor in a COBOL Program 11-3
Figure 14-1. Coding Transaction Control Statements in a C Program 14-1
Figure 14-2. Coding Transaction Control Statements in a COBOL Program 14-2
Figure 15-1. Compiling Embedded SQL C/C++ Programs With Embedded Module
Definitions 15-3
Figure 15-2. Compiling Embedded SQL C/C++ Programs With Module Definition
Files 15-6
Figure 15-3. c89 Generating Annotated Source With Embedded Module
Definitions 15-42
Figure 15-4. c89 Generating Module Definition Files 15-45
Figure 16-1. Compiling Embedded SQL COBOL Programs With Embedded Module
Definitions 16-3
Figure 16-2. Compiling Embedded SQL COBOL Programs With Module Definition
Files 16-6
Figure 16-3. ecobol or nmcobol Generating Annotated Source With Embedded
Module Definitions 16-38