List of Tables

2-1 Embedded SQL Statements

2-2 Executable SQL Statements and their Desccriptions

3-1 Internal Datatypes

3-2 Pseudocolumns and Internal Datatypes

3-3 Parameterless Functions

3-4 External Datatypes

3-5 DATE Datatype Example

3-6 Conversion Between Internal and External Datatypes

3-7 External Datatypes Parameters

3-8 VARNUM Example

3-9 Globalization Support Parameters

5-1 Legal Datatype Conversions

6-1 Precompiler Command

6-2 System Configuration File

6-3 Precompiler Options

6-4 DBMS and MODE Settings

6-5 File Extensions

6-6 SQLCHECK Checking

8-1 SQLCODE Declaration

8-2 SQLSTATE Declaration

8-3 ASSUME_SQLCODE=NO

8-4 ASSUME_SQLCODE=YES

8-5 Classes Predefined by SQL92

8-6 SQLSTATE Status Codes and Oracle Errors Mapping

8-7 Datatypes in SQLGLS Argument List

8-8 Function Code for SQL Commands

9-1 Valid Host Arrays Usage in a SELECT INTO Statement

9-2 Valid Host Arrays Usage in an UPDATE Statement

10-1 Methods and Kind of SQL Statements

B-1 Oracle Reserved Namespaces

C-1 HOLD_CURSOR and RELEASE_CURSOR

F-1 Functional Summary of Embedded SQL Commands and Directives