SQL Programming Manual for Pascal

Contents

HP NonStop SQL Programming Manual for Pascal—528614-001

vii

Figures (continued)

Figure 7-6. Checking Data Type 7-25

Figure 7-7. Allocating Memory for Values 7-26

Figure 7-8. Getting Parameter Values 7-29

Figure 7-9. Displaying Output 7-32

Figure A-1. Sample NonStop SQL Database Relations A-1

Figure A-2. Sample Database Source File A-2

Figure B-1. Date-Time Program Run B-7

Figure D-1. Developing and Installing a Generic Application D-15

Tables

Table 1-1. NonStop SQL Statements 1-2

Table 1-2. Host Language Directives 1-2

Table 2-1. Corresponding NonStop SQL and Pascal Data Types 2-3

Table 2-2. Date-Time and INTERVAL Data Types 2-9

Table 3-1. Summary of NonStop SQL Statements and Directives 3-3

Table 4-1. NonStop SQL System Procedures 4-1

Table 4-2. SQLCAGETINFOLIST Procedure Item Codes 4-10

Table 4-3. SQLCAGETINFOLIST Procedure Error Codes 4-12

Table 4-4. Version 2 (NonStop SQL C30) Features 4-20

Table 4-5. SQLSADISPLAY Procedure Display Elements 4-24

Table 5-1. Calculating Virtual Memory Requirements 5-32

Table 6-1. Pascal Compiler Pseudocode for Checking SQLCODE 6-4

Table 6-2. System Procedures for the SQLCA 6-9

Table 6-3. SQLSA Fields 6-11

Table 6-4. SQLDA Fields 6-17

Table 6-5. Data Type Values and Literal Declarations 6-19

Table 6-6. Literals for Date-Time and INTERVAL Data Types 6-20

Table 6-7. Literal Declarations for Ranges of Date-Time Fields 6-20

Table D-1. Summary of New Columns in Version 2 Catalogs D-3

Table D-2. Summary of Incompatible C30 Feature Changes D-4

Table D-3. Accessing Version 2 Objects from a Version 1 Application D-8

Table D-4. SQL C10 Versioning IPM Summary D-9