 |
|
Database Connectivity for DB2 LUW
|
Standard Edition
|
HiT OLEDB Server/DB2
HiT OLEDB Server/DB2 Developer Edition
HiT OLEDB Server/DB2 (for IBM DB2 for LUW or IBM DB2 for z/OS) is Windows middleware for DB2 SQL access from custom applications and third party products. HiT OLEDB Server/DB2 accepts application SQL commands via ADO or directly via its object properties and methods. It then translates these into native DB2 SQL for high-performance, communicates with the DB2 server to access, retrieve, and update data. All communication with the DB2 server can also be optionally encrypted and authenticated via SSL v3.0 support. Leveraging the IBM Distributed Relational Database Architecture protocol standard, HiT OLEDB Server/DB2 uses native IBM server programs and does not require any additional DB2 server software. HiT OLEDB Server/DB2 supports all Windows 32 and 64-bit client platforms including Windows Server 2008/2003/2000 and Windows NT Server.
HiT OLEDB Server/DB2 supports full SQL functionality for maximum application
performance including stored procedures, multiple result sets, and static SQL/packages. Multi-threading
and re-entrancy support ensure high performance for client applications. Its unique dbXpress
performance feature also significantly speeds applications. HiT OLEDB Server/DB2 can communicate
over TCP/IP or APPC connections.
OLEDB provider support includes data source, session, transaction, command,
rowset, and error COM objects. A complete set of
data type mapping between DB2 and OLE DB/ADO environments is supported and documented.
HiT OLEDB Server/DB2 database schema support is based on the ANSI SQL92
specification. Schema information retrieved using predefined schema rowsets via IDBSchemaRowset::GetRowset
interfaces. Applications can specify simple restrictions, such as returning all the columns in a
particular table.
Security is supported via the IDBProperties interface, where applications can
request the type of authentication/authorization mechanism they want to use.
Support is included for OLE DB v2.0 connection pooling. Support is included for OLE DB and ADO connection pooling.
The included OLEDB/Toolkit allows easy data link definition and diagnostics.
Additionally, it provides powerful trace and debugging tools to help troubleshoot and optimize application
performance, and convenient SQL package management.
HiT OLEDB Server/DB2 Developer Edition (DE) includes the C# Toolkit. It
contains source code examples for accessing data using ADO.NET. It significantly cuts
application development time by providing developers working C# samples to query and update DB2 tables and
retrieve DB2 data for redirection to applications. Included source code demonstrates connections using ADO.NET
recordsets, executing stored procedures, retrieving table data, inserting table data, and displaying results.
A client OLEDB provider, HiT OLEDB/DB2, is also available.
| Key Features |
 |
|
Benefits |
|
ADO level 2.x compliance
ADO.NET compliance |
|
|
Latest tools accessibility
|
|
Stored procedures and multiple result sets
support
Static SQL/package support
|
|
|
Fast data access
|
|
Distributed Transaction Support
|
|
|
Complex transactions support over multiple
databases |
|
| Multi-threading support |
|
|
Performance and scalability |
|
| dbExpress and Connection Pooling |
|
|
Performance |
|
SSL v3.x encryption and authentication
support |
|
|
Secure data transmission
|
|
| Multiple DB2 server version support |
|
|
Flexible deployment |
|
| Debug/trace tools |
|
|
Fast diagnostics |
|
| Silent install support |
|
|
Fewer IT support issues during deployment |
|
| TCP/IP or APPC connectivity support |
|
|
Common network transport |
|
| Double-byte support
|
|
|
International DB2 server access |
|
| DRDA Native protocol support
|
|
|
Server Stability |
|
Distributed program call support CL
Command Execution
|
|
|
Business logic and utility access
|
|
Complete set of data types supported
and documented
|
|
|
Seamless translation between EBCDIC and ANSI character sets |
|
HiT Server Manager and C# Toolkit
with Developer Edition
|
|
|
Remote monitoring management and
reduced development time |
|
| Supported DB2 Data Types |
|
In rowsets and as parameter values, HiT
OLEDB Server/DB2 maps DB2 data types to
OLE DB-defined data types. The following DB2 data types are supported: |
|
| DATE |
|
|
FIXED GRAPH |
|
| TIME |
|
|
VARGRAPH |
|
| TIMESTAMP |
|
|
LONG VARGRAPH |
|
| CHAR |
|
|
VARCHAR |
|
| LONG VARCHAR |
|
|
CHAR FOR BIT DATA |
|
| VARCHAR FOR BIT DATA |
|
|
LONG VARCHAR FOR BIT DATA |
|
| DECIMAL |
|
|
NUMBERIC |
|
| INTEGER |
|
|
SMALLINT |
|
| REAL |
|
|
FLOAT |
|
| Supported OLEDB Data Types |
|
| DBTYPE_12 |
|
|
DBTYPE_I4 |
|
| DBTYPE_R4 |
|
|
DBTYPE_R8 |
|
| DBTYPE_CY |
|
|
DBTYPE_DATE |
|
| DBTYPE_BSTR |
|
|
DBTYPE_IDISPATCH |
|
| DBTYPE_ERROR |
|
|
DBTYPE_BOOL |
|
| DBTYPE_VARIANT |
|
|
DBTYPE_IUNKNOWN |
|
| DBTYPE_DECIMAL |
|
|
DBTYPE_UI1 |
|
| DBTYPE_ARRAY |
|
|
DBTYPE_BYREF |
|
| DBTYPE_I1 |
|
|
DBTYPE_UI2 |
|
| DBTYPE_UI4 |
|
|
DBTYPE_I8 |
|
| DBTYPE_UI8 |
|
|
DBTYPE_GUID |
|
| DBTYPE_VECTOR |
|
|
DBTYPE_FILETIME |
|
| DBTYPE_BYTES |
|
|
DBTYPE_STR |
|
| DBTYPE_WSTR |
|
|
DBTYPE_NUMERIC |
|
| DBTYPE_DBDATE |
|
|
DBTYPE_DBTIME |
|
| DBTYPE_DBTIMESTAMP |
|
|
DBTYPE_VARNUMERIC |
|
Data Source Object Interfaces
· IDBCreateSession
· IDBInitialize
· IDBProperties
· IPersistFile
· IPersist
· ISupportErrorInfo
· IDBInfo
· IDBDataSourceAdmin
Session Object Interfaces
· IGetDataSource
· IOpenRowset
· ISessionProperties
· IObjectWithSite
· IDBCreateCommand
· IDBSchemaRowset
· ISupportErrorInfo
· IIndexDefinition
· ITransactionLocal
Transaction Object Interfaces
· Itransaction
· ItransactionLocal
Command Object Interfaces
· ICommand
· IObjectWithSite
· IAccessor
· ICommandProperties
· ICommandText
· IColumnsInfo
· IConvertType
· ICommandPrepare
· ICommandWithParameters
· ISupportErrorInfo
· IColumnsRowset
Rowset Object Interfaces
· IAccessor
· IRowsetInfo
· IColumnsInfo
· IConvertType
· IMultipleResults
· IObjectWithSite
· IRowsetIdentity
· IRowset
· IRowsetChange
· IRowsetLocate
· ISequentialStream
· ISupportErrorInfo
· IColumnsRowset
Error Lookup Object Interfaces
· IErrorLookup
Schema Rowset Support
The following schema tables are supported by HiT OLEDB Server/400
(for each schema table the supported columns are listed):
· Schema Rowset GUID
· DBSCHEMA_TABLES
· DBSCHEMA_COLUMNS
· DBSCHEMA_PROVIDER_TYPES
· DBSCHEMA_CATALOGS
· DBSCHEMA_INDEXES
· DBSCHEMA_SCHEMATA
· DBSCHEMA_PROCEDURES
· DBSCHEMA_PROCEDURES_PARAMETERS
System Requirements:
For the Workstation Client
· Windows NT Server 4.0 and later
· Microsoft Internet Information Server (for ODBC Thin Client Applications)
· TCP/IP or APPC connection to the DB2 Server
Server Requirements:
For the Windows Server
· Windows Server 2008 (32/64-bit), Windows Server 2003 (32/64 bit), Windows Server 2000 or
Windows NT Server 4.0
· TCP/IP or APPC connection to the DB2 Server
For the DB2 Server
· OS/390:
DB2 UDB v5 or later
· DB2 LUW Server:
DB2 UDB v5 or later
· DB2 for i Server
OS/400 v3r7 or later
TCP/IP supported from OS/400 v4r2 or later
Standard Edition
Full Support
during Trial Period |
Developer Edition
Full Support
during Trial Period |
| 
Std. Edition
View
Std. Edition
