 |
|
Database Connectivity for IBM i
|
Standard Edition
|
HiT OLEDB Server/400
HiT OLEDB Server/400 Developer Edition
SQL MIDDLEWARE FOR WINDOWS SERVERS
HiT OLEDB Server/400 is Windows middleware for IBM DB2 for i SQL access from custom server
applications and third party products. HiT OLEDB Server/400 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 IBM i to access, retrieve, and
update DB2 data. All communication with the IBM i can also be optionally encrypted and authenticated
via SSL v3.0 support. Leveraging the IBM Optimized Database Server protocol standard, HiT OLEDB
Server/400 uses native IBM server programs and does not require any additional software on the
IBM i platform. HiT OLEDB Server/400 supports Windows 32 and 64-bit server platforms including
Windows Server 2008/2003/2000 and Windows NT 4.0.
HiT OLEDB Server/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.
Leveraging the IBM i's Optimized Database Server subsystem, HiT OLEDB Server/400 can communicate over
TCP/IP or APPC connections and supports all operating system versions after V3R7. To ensure high application
performance, HiT OLEDB Server/400 supports the most flexible NT Server multi-threading models.
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/400 database schema support is based on the ANSI SQL92
specification. Schema information retrieved using predefined schema rowsets via I
DBSchemaRowset::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 and ADO connection pooling.
The included OLEDB Toolbox allows easy data link definition and diagnostics.
Additionally, the HiT OLEDB/Workshop, included in the Developer Edition, provides powerful trace and
debugging tools to help troubleshoot and optimize application performance, and convenient SQL package
management.
A Developer Edition of the product drastically cuts web application
development time by providing developers with a C# Toolkit. Using ADO.NET,
C# toolkit samples show you how to query and update IBM DB2 for i tables, control related i OS
subsystems, and retrieve DB2 data for redirection to web 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 OS/400 or IBM i operating
systems V3R7 or higher.
A client OLEDB provider, HiT
OLEDB/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 and 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 |
|
HiT Server Manager and C# Toolkit
with Developer Edition
|
|
|
Remote monitoring management and
reduced development time |
|
| Supported DB2/400
Data Types |
|
In rowsets and as parameter values, HiT
OLEDB Server/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 |
|
|
| 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 Windows Server
· Windows Server 2008 (32/64-bit), Windows Server 2003 (32/64 bit), Windows Server 2000 or
Windows NT Server 4.0
· Network card operable with network protcols
· 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
