|
HiT OLEDB/DB2
HiT OLEDB/DB2 Developer Edition
SQL MIDDLEWARE FOR WINDOWS CLIENTS
HiT OLEDB/DB2 (for OLE DB DB2 or mainframe) is Windows client middleware for DB2 SQL access from
custom applications and third party products. HiT OLEDB/DB2 accepts
application SQL commands via ADO v2.x 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/DB2 (for OLEDB DB2 or mainframe) uses native IBM server programs
and does not require any additional DB2 server software. HiT OLEDB/DB2
supports all Windows 32-bit client platforms including Windows 2000,
98/95, and NT Workstation.
HiT OLEDB/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/DB2 can communicate over TCP/IP or SNA
connections.
OLEDB provider support includes data source, session, transaction, command,
rowset, and error COM objects. (Distributed transactions are supported for TCP/IP connections to the
mainframe and will be supported on other platforms when DB2 v7 becomes available.) A complete set of
data type mapping between DB2/400 and OLE DB/ADO environments is supported and documented.
HiT OLEDB/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. ADO v2.0 connection
pooling, as an OLE DB v2.0 consumer, is therefore also supported.
The included OLEDB Toolbox allows easy data link definition and diagnostics.
Additionally, powerful trace and debugging tools to help troubleshoot and optimize application
performance, and convenient SQL package management.
HiT OLEDB/DB2 Developer Edition includes the HiT Visual Basic Toolkit
containing source code examples for accessing data using ActiveX Data Objects 2.0 (ADO). It
significantly cuts application development time by providing developers working VB project and
samples to query and update DB2 tables and retrieve DB2 data for redirection to applications.
Included source code demonstrates connections using ADO recordsets, executing stored procedures,
retrieving table data, inserting table data, and displaying results.
A server OLEDB provider, HiT
OLEDB Server/DB2, is also available.
| Key Features |
 |
|
Benefits |
 |
|
ADO level 2.x 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 |
|
|
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 SNA 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 |
|
| VB toolkit with Developer Edition
|
|
|
Development time reduced |
|
| Data Types |
|
|
In rowsets and as parameter values, HiT OLEDB/DB2 maps DB2/400 data types to
OLE DB-defined data types. The following DB2/400 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/DB2 (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:
Installation
· Windows Vista (32/64 bit)/XP/2000
For the Workstation Client
· Pentium processor or better
· Windows 95/98/NT Workstation v4.0
· 32MB Memory
· 6MB Disk Space
· Network card operable with TCP/IP network protcols
· TCP/IP or APPC connection to the DB2 Server
For the DB2 Server
· OS/390
DB2 UDB v5 or later
· MVS Requirements
DB2 UDB v5 or later
VTAM® 3.3 or later
· VM Requirements
SQL™DS® v3.4 or later
VM/SP Release 6 or later
SQL™DS® v3.4 or later
VTAM® 3.2 or later
· NT/OS2/AIX/DB2 Server:
DB2 UDB v5 or later
· OS/400
DB2 OS/400 v2r2 or later
TCP/IP supported from OS/400 v4r2 or later
| 
