SQL Programming Manual for TAL

Contents
HP NonStop SQL Programming Manual for TAL—527887-001
vi
Figures (continued)
Figures (continued)
Figure A-1. Sample NonStop SQL Database Relations A-2
Figure A-2. Sample Database Source File A-3
Figure B-1. Insertion Program Output B-2
Figure B-2. Date-Time Program Run B-12
Figure C-1. Output for the Dynamic SQL Program C-2
Figure C-2. Output for the Detailed Dynamic SQL Program C-11
Figure D-1. Developing a Program For Mixed-Version Nodes D-15
Tables
Table 1-1. NonStop SQL Statements 1-2
Table 1-2. NonStop SQL Directives 1-3
Table 2-1. Corresponding NonStop SQL and TAL Data Types 2-3
Table 2-2. Default and Override Data Type Mapping 2-6
Table 2-3. Date-Time and INTERVAL Data Types 2-16
Table 2-4. INVOKE Directive Override Data Type Mapping 2-20
Table 3-1. Summary of NonStop SQL Statements and Directives 3-4
Table 3-2. INVOKE Directive Override Data Type Mapping 3-23
Table 3-3. NonStop SQL Data Structures 3-38
Table 4-1. System Procedures for NonStop SQL Operations 4-1
Table 4-2. SQLCAGETINFOLIST Procedure Item Codes 4-11
Table 4-3. SQLCAGETINFOLIST Procedure Error Codes 4-12
Table 4-4. NonStop SQL Release C30 (Version 2) Features 4-20
Table 4-5. SQLSADISPLAY Procedure Display Elements 4-23
Table 5-1. Calculating Virtual Memory Requirements for Each SQL Statement or
Directive 5-33
Table 6-1.
TAL Compiler Pseudocode for Checking SQLCODE 6-4
Table 6-2.
System Procedures for the SQLCA Structure 6-9
Table 6-3. SQLSA Fields 6-11
Table 6-4. SQLDA Fields 6-17
Table 6-5. Literal Declarations for Character, Numeric, and Decimal Values 6-19
Table 6-6. Literal Declarations for Date-Time and INTERVAL Values 6-19
Table 6-7. Literal Declarations for Ranges of Date-Time Fields 6-20
Table 7-1. Literal Declarations for Data Types 7-21
Table D-1. Version 2 Items and Descriptions D-2
Table D-2. Version 1 Items and Descriptions D-2
Table D-3. Summary of New Columns in Version 2 Catalogs D-3
Table D-4. Incompatible NonStop SQL Release C30 Features D-4