Advanced Database Feature Guide
This section lists the versions and capabilities of DB2 that the
Advanced Database feature supports.
This feature works with version 5.x and 6.1 of the UDB DB2
Client Application Enablers (CAE). The feature will automatically
detect the version of software installed on your system and will use the
appropriate CLI calls.
The following list of DB2 data types are supported by this feature:
- DATE
- TIME
- TIMESTAMP
- DOUBLE
- FLOAT
- REAL
- BIGINT (DB2 CAE Version 5.2 or later)
- INTEGER
- SMALLINT
- DECIMAL
- NUMERIC
- CHAR
- VARCHAR
- LONG VARCHAR
- CLOB
- CLOB LOCATOR
- BINARY (i.e. CHAR FOR BIT DATA)
- VARBINARY (i.e. VARCHAR FOR BIT DATA)
- LONG VARBINARY (i.e. LONG VARCHAR FOR BIT DATA)
- BLOB
- BLOB LOCATOR
- GRAPHIC *
- VARGRAPHIC *
- LONG VARGRAPHIC *
- DBLOB *
- DBLOB LOCATOR *
Note: | * These data types are only supported on databases with a code page that
supports double byte characters.
|
Most DB2 CLI Features are supported. However, the following list of
Advanced DB2 CLI features has been included for clarity purposes.
- The driver connect completion mode SQL_DRIVER_NOPROMPT
- The use of arrays to input multiple parameter values
- The retrieval of a result set into an array
- Compound SQL
- LOB and LOB Locators
- User Defined Types (UDT)
- Stored Procedures
- Asynchronous Function Calls
- Vendor Escape Clauses
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]