SQL/MP Programming Manual for C

Contents
HP NonStop SQL/MP Programming Manual for C—429847-008
viii
Examples (continued)
Examples (continued)
Example 10-8. Detailed Dynamic SQL Program 10-44
Example A-1. COPYLIB File for Sample Database A-3
Example D-1. Version 2 SQLDA Structure D-4
Example D-2. Version 1 SQLDA Structure D-6
Figures
Figure i. NonStop SQL/MP Library xvii
Figure ii. Program Development, System and OSS Manuals xviii
Figure 6-1. Explicit SQL Compilation of a C Program on TNS 6-3
Figure 6-2. Explicit SQL Compilation of a C Program on TNS/R 6-4
Figure 6-3. Explicit SQL Compilation of a C Program on TNS/E 6-5
Figure 6-4. SQL/MP Program File Format 6-24
Figure 7-1. Processes Running on a NonStop System 7-4
Figure 8-1. Timestamp Check 8-8
Figure 10-1. DESCRIBE INPUT’s Effect on Names Buffer 10-18
Figure A-1. SQL/MP Sample Database Relations A-2
Tables
Table i. NonStop SQL/MP Library xvi
Table ii. Program Development Manuals xix
Table iii. Guardian Manuals xx
Table iv. Open System Services (OSS) Manuals xx
Table 1-1. SQL/MP Statements and Directives 1-3
Table 2-1. Corresponding SQL and C Character Data Types 2-3
Table 2-2.
Corresponding SQL and C Numeric, Date-Time, and INTERVAL Data
Types 2-4
Table 2-3.
Date-Time and INTERVAL Data Types 2-13
Table 3-1. Summary of SQL/MP Statements and Directives 3-3
Table 3-2.
C Compiler Pragmas for SQL/MP 3-7
Table 4-1. SQL/MP Statements for Data Retrieval and Modification 4-1
Table 4-2.
Determining the Cursor Position 4-16
Table 5-1.
SQL/MP System Procedures 5-1
Table 5-2. Guardian System Procedures That Return SQL Information 5-2
Table 5-3.
SQLCAGETINFOLIST Procedure Error Codes 5-11
Table 5-4.
SQLCAGETINFOLIST Procedure Item Codes 5-11
Table 5-5.
SQLSADISPLAY Procedure Display Elements 5-22
Table 6-1.
C Compilers 6-2
Table 6-2. Compilation Mode and Execution Environment 6-2