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

Contents

HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004

xiv

Figures (continued)

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-39

Figure 15-4. c89 Generating Module Definition Files 15-41

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. nmcobol Generating Annotated Source With Embedded Module

Definitions 16-35

Figure 16-4. nmcobol Generating Module Definition Files 16-37

Figure 17-1. Module Name Length 17-11

Tables

Table 2-1. MODULE Directive 2-6

Table 2-2. Embedded SQL Statements in SQL Declare Section 2-6

Table 2-3. Nonexecutable SQL Statements 2-7

Table 2-4. Executable SQL Statements 2-8

Table 3-1. Corresponding SQL, C Host Variable Data Types, and Translated C

Declarations for NUMERIC, DECIMAL, PIC, SMALLINT, and LARGEINT

Data Types 3-8

Table 3-2.

Corresponding SQL, C Host Variable Data Types, and Translated C

Declarations for Float Data Types 3-9

Table 3-3. Corresponding SQL, C Host Variable Data Types, and Translated C

Declarations for Date-Time Data Types 3-9

Table 3-4. Corresponding SQL, C Host Variable Data Types, and Translated C

Declarations 3-10

Table 3-5. Host Variable Usage for NUMERIC or PICTURE 9’s COMP Data 3-20

Table 3-6. Host Variable Usage for DECIMAL or PICTURE 9’s DISPLAY

Data 3-20

Table 3-7. Lengths of C Target Arrays for TIME and TIMESTAMP 3-24

Table 3-8. INVOKE and Floating-Point Host Variables 3-33

Table 4-1. COBOL Character Host Variables and Their SQL Data Type Equivalents

and COBOL Translations 4-5