|
HiT OLEDB Server/400
HiT OLEDB Server/400 Developer Edition
SQL MIDDLEWARE FOR WINDOWS SERVERS
HiT OLEDB Server/400 (for OLE DB DB2 or mainframe) is Windows middleware for DB2/400 SQL access from custom server applications and third
party products. HiT OLEDB Server/400 accepts application SQL commands via ADO v2.x or directly via its
object properties and methods. It then translates these into native DB2/400 SQL for high-performance,
communicates with the AS/400 to access, retrieve, and update DB2/400 data. All communication with the
AS/400 can also be optionally encrypted and authenticated via SSL v3.0 support. Leveraging the IBM
Optimized Database Server protocol standard, HiT OLEDB Server/400 (for OLE DB DB2 or mainframe) uses native IBM server programs and
does not require any additional AS/400 software. HiT OLEDB Server/400 supports Windows 32-bit server
platforms including Windows NT 4.0 and Windows 2000.
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 OS/400’s Optimized Database Server subsystem, HiT OLEDB Server/400 can communicate over
TCP/IP or APPC connections and supports all OS/400 versions after V3R1. 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. (Distributed transactions will be supported 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 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 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, 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 working Active Server Page and Visual Basic samples. Using ActiveX Data
Objects 2.0 (ADO), ASP and VB samples show you how to query and update DB2/400 tables, control related
OS/400 subsystems, and retrieve DB2/400 data for redirection to web 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 client OLEDB provider, HiT
OLEDB/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 and 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 |
|
HiT Server Manager
|
|
|
Remote monitoring
management |
|
ASP and VB toolkit included with
Developer Edition
|
|
|
Development time reduced
|
|
| Supported DB2/400
Data Types |
|
In rowsets and as parameter values, HiT
OLEDB Server/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 |
|
|
| 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 2003 (32/64 bit), Windows Server 2000
or Windows NT Server 4.0
· 12Mb Disk Space
· Network card operable with network protcols
· TCP/IP or APPC connection to the AS/400
For the DB2 Server
· OS/400 V3R1 through IBM i 6.1 (i5/OS V6R1)
| 
