Purchase

USA and Canada
sales@hitsw.com
+1-408-345-4001
 
Asia
Australia
Europe
Latin America

Database Connectivity for DB2 LUW

Standard Edition with Full 14-Day Support

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
 

Standard Edition with Full 14-Day Support

Developer Edition with Full 14-Day Support