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

xiv

Figures (continued)

Figure 16-4. ecobol or nmcobol Generating Module Definition Files 16-41

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

Table 4-2. Corresponding SQL, COBOL Host Variable Data Types, and Translated

COBOL Declarations for NUMERIC, DECIMAL, PIC, SMALLINT,

LARGEINT, and Date-Time Data Types 4-7

Table 4-3. Lengths of Target Arrays for TIME and TIMESTAMP 4-14

Table 4-4. Interpretation of COBOL Data Description Clauses 4-18

Table 4-5. Changes Made by INVOKE in Generated Host Variables 4-27

Table 12-1. Minimum Values for ROWSET_VAR_LAYOUT_SIZE Descriptor

Field 12-7

Table 13-1. SQL:1999 SQLSTATE Class and Subclass Values 13-2

Table 13-2. Mapping of SQLCODE to SQL/MX-Defined SQLSTATE Values 13-3

Table 13-3. SQLCODE Values 13-6

Table 15-1. HP NonStop C/C++ Compilers for Embedded SQL/MX

Programs 15-28

Table 15-2. Module Schemas and Export Files for RDF SQL Application

Deployment Example 15-54