SQL/MP Programming Manual for COBOL

Contents
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
ix
Figures
Figures
Figure i. NonStop SQL/MP Library xiv
Figure 2-1. DATE Representation 2-20
Figure 2-2. INTERVAL Representation 2-20
Figure 4-1. Using a Static SQL Cursor in a COBOL Program 4-12
Figure 6-1. Compiling a COBOL Program in TNS Mode 6-2
Figure 6-2. Compiling a COBOL Program in TNS/R Native Mode 6-4
Figure 6-3. Accelerated SQL Program File 6-24
Figure 6-4. SQL Program File Format 6-38
Figure 8-1. Timestamp Check 8-8
Figure 10-1. Static and Dynamic SQL Programs 10-3
Figure 10-2. Names Buffer Structure 10-24
Figure A-1. SQL/MP Sample Database Relations A-2
Tables
Table i. NonStop SQL/MP Library xiii
Table ii. Program Development Manuals xv
Table iii. Guardian Manuals xvi
Table iv. Open System Services (OSS) Manuals xvi
Table 1-1. SQL/MP Statements and Directives 1-3
Table 2-1. Corresponding SQL and COBOL Data Types 2-3
Table 3-1. NonStop SQL/MP Statements and Directives 3-3
Table 3-2. COBOL Compiler Directives for SQL/MP 3-7
Table 4-1. SQL/MP Statements for Data Retrieval and Modification 4-1
Table 5-1. SQL/MP System Procedures 5-1
Table 5-2.
Guardian System Procedures that Return SQL Information 5-2
Table 6-1.
HP COBOL Compilers 6-12
Table 6-2.
COBOL Compilation Mode and Execution Environment 6-12
Table 6-3. Environment Variables in the OSS Environment 6-16
Table 9-1. SQLCA Structure Fields 9-13
Table 9-2.
SQLSA Structure Fields 9-23
Table 10-1.
SQL Statements Used for Dynamic SQL Operations 10-1
Table 10-2. SQLDA Structure Fields 10-12
Table 10-3.
SQLDA DATA-TYPE Values 10-13
Table 10-4.
SQLSA Contents after a Prepare Operation 10-18
Table 11-1.
Character Processing Rules (CPRL) Procedures 11-1
Table D-1.
SQL Data Structures D-1
Table D-2. Version 2 SQLDA Structure Fields D-3
Table D-3.
Version 1 SQLDA Structure Fields D-6