|
HiT OLEDB/400
HiT OLEDB/400 Developer Edition
SQL MIDDLEWARE FOR WINDOWS CLIENT PLATFORMS
HiT OLEDB/400 (OLE DB for System i, i5, iSeries or AS/400) is Windows client middleware for DB2/400 SQL access from custom applications and third party
products. HiT OLEDB/400 accepts application SQL commands via ADO v2.x or directly via its object properties
and methods. It then translates these SQL commands into native DB2/400 SQL for high-performance access and
communicates with the IBM System i (formerly AS/400) to access, retrieve, and update DB2/400 data. All
communication with the iSeries can also be optionally encrypted and authenticated via SSL v3.0 support.
Leveraging the IBM Optimized Database Server protocol standard, HiT OLEDB/400 (OLE DB for System i, i5, iSeries or AS/400) uses
native IBM server programs and does not require any additional iSeries software. HiT OLEDB/400 supports all
Windows 32-bit client platforms including Windows 2000 Professional, 98/95, and NT Workstation.
HiT OLEDB/400 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/400 supports OS/400 versions V3R1 and later and can communicate over
TCP/IP or APPC connections. To ensure high performance client applications, HiT OLEDB/400 supports the
most flexible Windows 32-bit multi-threading models.
OLEDB provider support includes data source, session, transaction, command, rowset,
and error COM objects. A broad set of data type mapping between DB2/400 and OLE DB/ADO environments is
supported, including binary and character large objects.
HiT OLEDB/400 database schema support is based on the ANSI SQL92 specification.
Schema information is retrieved using predefined schema rowsets through the IDBSchemaRowset::GetRowset
interfaces. Applications can specify simple restrictions, such as returning a particular table’s
columns.
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.x connection pooling. ADO v2.x 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, the HiT OLEDB Toolbox provides powerful trace and debugging tools to help troubleshoot
and optimize application performance, and convenient SQL package management.
HiT OLEDB/400 Developer Edition includes the HiT Visual Basic Toolkit
containing source code examples for accessing data using ActiveX Data Objects (ADO). It significantly
cuts application development time by providing developers working VB project and samples to query and
update DB2/400 tables, control related OS/400 subsystems, and retrieve DB2/400 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. All samples work with
any OS/400 V3R1 through IBM i 6.1 (i5/OS V6R1) system.
A server OLEDB provider, HiT
OLEDB Server/400, 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 Connection Pooling |
|
|
Performance |
|
SSL v3.x encryption and
authentication support |
|
|
Secure data transmission
|
|
| Multiple OS/400 version support |
|
|
Flexible deployment |
|
| Debug/trace tools |
|
|
Fast diagnostics |
|
Silent install support
|
|
|
Fewer IT support issues
during deployment |
|
| TCP/IP connectivity support |
|
|
Common network transport |
|
Double-byte support
|
|
|
International DB2 server
access |
|
OS/400 ODBS 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 |
|
| Supported DB2/400
Data Types |
|
| In rowsets and as parameter values, HiT OLEDB/400 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 |
|
| BLOB |
|
|
CLOB |
|
| 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/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
· Pentium processor or better
· Windows Vista (32/64 bit)/XP/2000
· 32MB Memory
· 6MB Disk Space
· Network card operable with TCP/IP network protcols
· TCP/IP or APPC connection to the DB2/400 Server
For the DB2 Server
· OS/400 V3R1 through IBM i 6.1 (i5/OS V6R1)
| 
