SQL/MP Programming Manual for COBOL85

Contents

HP NonStop SQL/MP Programming Manual for COBOL85—429326-004

Figures (continued)

Figure 6-1. Compiling a COBOL Program 6-2

Figure 6-2. SQL Program File Format 6-35

Figure 8-1. Timestamp Check 8-8

Figure 10-1. Static and Dynamic SQL Programs 10-2

Figure 10-2. Names Buffer Structure 10-24

Figure A-1. SQL/MP Sample Database Relations A-2

Tables

Table 1. NonStop SQL/MP Library xiii

Table 2. Program Development Manuals xv

Table 3. Guardian Manuals xvi

Table 4. 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-2

Table 3-1. NonStop SQL/MP Statements and Directives 3-3

Table 3-2. COBOL85 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. OSS cobol Utility Flags 6-14

Table 6-2. Environment Variables in the OSS Environment 6-17

Table 6-3. OSS nmcobol Utility Flags 6-19

Table 9-1. SQLCA Structure Fields 9-12

Table 9-2. SQLSA Structure Fields 9-22

Table 10-1. SQL Statements Used for Dynamic SQL Operations 10-1

Table 10-2. SQLDA Structure Fields 10-11

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