 |
|
Database Connectivity for IBM i
|
Standard Edition
|
HiT OLEDB/400
SQL MIDDLEWARE FOR WINDOWS CLIENT PLATFORMS
HiT OLEDB/400 (OLE DB for IBM i, iSeries or AS/400) is Windows client middleware for SQL access to IBM
DB2 for i servers from custom applications and third party products. HiT OLEDB/400 accepts application SQL
commands via ADO or directly via its object properties and methods. It then translates these SQL commands
into native DB2 SQL for high-performance access and communicates with the IBM i (iSeries, AS/400)
to access, retrieve, and update DB2 data. All communication with the IBM DB2 for i server can also be optionally encrypted
and authenticated via SSL v3.0 support.
Leveraging the IBM Optimized Database Server protocol standard, HiT OLEDB/400 uses
native IBM server programs and does not require any additional software running on the IBM i platform. HiT OLEDB/400 supports all
Windows 32-bit and 64-bit client platforms including Windows 7, Vista, XP, Windows 98/95, and Windows 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 versions V3R7 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 and 64-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 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 and ADO connection pooling.
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 C# toolkit and contains source
code examples for accessing data using ADO.NET. The toolkit significantly cut
application development time by providing developers with samples to query and update DB2 tables, control
related OS subsystems, 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. All samples work with any operating system, V3R7 or higher.
A server OLEDB provider, HiT
OLEDB Server/400, is also available.
Standard Edition
Full Support
during Trial Period |
Developer Edition
Full Support
during Trial Period |
| 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 Connection Pooling |
|
|
Performance |
|
SSL v3.x encryption and authentication
support |
|
|
Secure data transmission
|
|
| Multiple OS 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 |
|
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 |
|
| C# toolkit included with Developer Edition
|
|
|
Reduced development time |
|
| Supported DB2/400
Data Types |
|
In rowsets and as parameter values, HiT OLEDB/400 maps IBM DB2 for i
data types to
OLE DB-defined data types. The following 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
· Windows 7 (32-bit/64-bit), Windows XP, Windows Vista (32-bit/64-bit), Windows 98/95,
Windows NT Workstation
· Support for TCP/IP or APPC network protocols
For the DB2 Server
· OS/400 or IBM i operating system V3R7 or higher
Standard Edition
Full Support
during Trial Period |
Developer Edition
Full Support
during Trial Period |
| 
Std. Edition
View
Std. Edition
