|
|
The development of sophisticated applications that exploit advanced features of relevant industry standards.
| Feature Category |
Features |
| Performance |
|
| Multithreaded |
Enables exploitation of scalability benefits arising from the use of multiple CPUs or Clusters while developing or using DBMS independent applications. |
| Deferred Fetching of Blob Data |
The SQLGetData() and SQLPutData() ODBC API implementations have been significantly enhanced to provide intelligent handling of BLOB data. This facilitiates transferring parameter data in parts over the network between the generic client and database agents. Once transferred, the fragmented column data is reassembled in its entirety within the client and or database agent parts of the multi-tier driver (depending on if this is an insert or retrieval). The feature applies to the following datatypes:
SQL_BLOB, SQL_CLOB, SQL_DBCLOB.
If the long data compatibility option has been specified in the DB2 database then datatype support would include:
SQL_LONGVARCHAR, SQL_LONGVARBINARY, and SQL_LONGVARGRAPHIC.
However, if a table contains a column defined as one of these "long" types, but the actual data stored in the column only fills a small proportion of the available space, deferred fetching is of no benefit. In these cases, performance may be improved by switching off the deferred fetching mechanism using the control in the OpenLink Generic Client data source setup dialog. |
|
| Usability |
|
| Multithreading support |
Enables development, deployment, and use of multithreaded client applications |
|
| Standards Compliance |
|
| Supports Advanced Data Access API functionality |
Enables the development and utilization of DBMS application with DBMS independent granularity that extends to challenging areas such as scalar function calls, dates and timestamps manipulation, outer join handling, and SQL stored procedure invocation etc. |
| Complete ODBC Scrollable Cursor Model Support |
Provides ODBC compliant applications with a flexible model for handling sensitivity to data changes using the following scrollable cursor models: Forward-Only, Static, KeySet, Dynamic, and Mixed. |
| Support for SQLCancel() API call support |
Provides the ability to cancel long running queries |
|
Product Availability
| Database |
Version |
Operating System |
Version |
Processor |
Mode |
Upwards Compatible |
Try / Buy |
|
DB2
|
6.x - 9.x
|
Windows
|
98/NT/2000/XP/2003
|
x86
|
32 Bit
|
Y
|
Release 6.1
|
|
|
|
Use the tabs above to select the operating system upon which to filter availability.
|
|
|
-
Business
-
Technical
-
Partner
|
|
|