Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website



Database Connectivity Overview

pdfPDF
Case Studies

case studiesView
Download

HiT OLEDB ProductsOLEDB for DB2


Purchase

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

as/400 iseries odbc driver for sql server : db2 connectivity

ODBC driver for IBM i, iSeries and AS/400  


OLEDB Connectivity
for IBM DB2 for Linux, UNIX, Windows, z/OS

The HiT OLE DB product family consists of HiT OLEDB/400 and HiT OLEDB Server/400, designed specifically to access DB2 data on IBM OS/400 platforms, IBM i, iSeries and AS/400. HiT OLEDB/DB2 and HiT OLEDB Server/DB2, are designed to access DB2 data on z/OS and OS/390, VSE/VM, AIX, Solaris, Linux, OS/2 and Windows.

All products support full SQL functionality for maximum application performance including stored procedures, multiple result sets, static SQL/packages, multi-threading support. Direct connectivity architectures ensure superior performance and simplified support. HiT OLEDB products are a native fit for developers working in Visual Basic and other ADO IDE tools.   HiT OLEDB Family
  OLEDB for i
  OLEDB for DB2 LUW

For both third-party commercial applications and custom applications, the HiT OLEDB family of products provides high-performance, secure, reliable access to DB2 data. Enterprises looking for an OLEDB solution to access DB2 data should consider HiT OLEDB products for the following reasons:

  • Effective use of native IBM protocols for performance and reliability
  • Non-invasive approach with no software to install on DB2 servers
  • Secure data transmission when used with HiT SafeConduct for data encryption and digital certificate authentication
  • Tools for diagnosing problems and monitoring server activity
  • Developer editions with source code examples
     

Overview of HiT OLEDB for IBM DB2 LUW and z/OS

HiT OLEDB/DB2 products (for DB2 LUW and z/OS or OS/390) are Windows middleware for DB2 SQL access from custom applications and third party products. HiT OLEDB/DB2 products accept application SQL commands via ADO or directly via object properties and methods. They then translate these into native DB2 SQL for high-performance, communicate 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 products use native IBM server programs and do not require any additional DB2 server software to be installed.

  • 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 APPC connections.
  • 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/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 and ADO connection pooling.
  • 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.
     

download : includes full support during trial

 
Key Features   Benefits
ADO level 2.x compliance
.NET framework 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
dbXpress and Connection Pooling   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 connectivity support   Common network transport
Double-byte and Middle Eastern
language 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
C# toolkit included with Developer Edition
HiT Server Manager included with
Server Developer Edition.
  Development time reduced
 
 


HiT 
            OLEDB for DB2: Client and Server Edition

Security

HiT OLEDB/DB2 can be used with HiT SSL Server, an all-Java, standards-based encryption and authentication server to secure SQL data flows over TCP/IP networks. It prevents unauthorized access to data by transparently enabling the Secure Socket Layer (SSL) protocol between HiT OLEDB/DB2 and the system where HiT SSL Server is installed.
 
In the Server version, HiT OLEDB/DB2 allows an administrator to pre-define data sources for server and downstream Windows clients. These data sources are maintained at the server and cannot be modified. HiT OLEDB/DB2 also supports IBM DB2 password expiration security. A read-only version driver is included for query-only client applications.

Server Version

HiT Software provides a Server version of this product, called HiT OLEDB/Server DB2, The Server version includes all the features above as well as the HiT Server Manager, which allows a remote developer or administrator to see OLE DB connections by DB2 server, calling application and user ID, start time of connections, status of connection, traffic volume over connection, and memory utilization. DB2 server connections can be pooled and reused to optimize performance. The HiT Server Manager can define the time-out and dropping of these pooled connections. Developer and administrators can monitor the DB2 middleware access layer to ensure maximum Windows server application performance.
 
HiT OLEDB Server/DB2 supports all Windows 32 and 64-bit server platforms, including the latest.
 
HiT Software also provides a Server version of the Developer Edition of this product, called HiT OLEDB/Server DB2 Developer Edition. This product includes all the same standard features, plus the HiT Server Manager (see HiT Server Manager features above).

Developer Edition

HiT OLEDB/DB2 Developer Edition includes the basic HiT OLEDB/DB2 functionality described above and a C# Toolkit, which contains source code examples for accessing data using ADO.NET. It significantly cuts application development time by providing developers working C# samples to query and update DB2 tables 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.

System Requirements:
    HiT OLEDB/DB2
(installed on client operating systems)
  HiT OLEDB Server/DB2
(installed on server operating systems)
Installation
Requirements

  Windows 32 and 64-bit client platforms
Microsoft Data Access Components
  (MDAC) v2.5 or higher
  Windows 32 and 64-bit server platforms
12Mb Disk Space
Network card operable with network
  protocols
TCP/IP or APPC connection to the
  DB2
Connectivity
  Support for TCP/IP network protocol
DB2 Server Requirements   DB2 LUW: DB2 v5 or later
DB2 for zOS/OS390: DB2 for OS/390 v5 or later


download : includes full support during trial

Supported DB2 Data Types
In rowsets and as parameter values, HiT OLEDB/DB2 maps DB2 data types to
OLE DB-defined data types. The following DB2 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

Supported Data Types
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   GRAPHIC
CLOB   BIGINT
TINYINT   BIT
DOUBLE PRECISION   BINARY
VAR BINARY   LONG VAR BINARY

HiT OLEDB/DB2 API

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

download : includes full support during trial

2016 HiT Software, Inc., A BackOffice Associates, LLC Company. All Rights Reserved.