HiT ODBC/DB2
HiT ODBC/DB2 Developer Edition

HiT ODBC/DB2 (for ODBC DB2 or ODBC mainframe) is Windows SQL client middleware for DB2 data access of custom applications and third party products. HiT ODBC/DB2 accepts standard Windows Open Database Connectivity (ODBC) function calls, translates these into native DB2 SQL for high-performance, and communicates with the DB2 server to access, retrieve, and update DB2 data. All communication with the DB2 server can also be optionally authenticated and encrypted via SSL v3.0 support. Leveraging the IBM Distributed Relational Database Architecture (DRDA) protocol standard, HiT ODBC/DB2 uses native IBM server programs and does not require any additional DB2 server software. DB2 UDB for OS/390 as well as other DB2 UDB servers are supported. HiT ODBC/DB2 supports all Windows client platforms including Windows 2000, 98/95, NT Workstation, and 3.x. It is also fully Y2K compliant.

As a third generation middleware product, HiT ODBC/DB2 v3.1 is extremely reliable and has evolved a robust feature set. Multi-threading support and re-entrancy support ensure the scalability and high performance for client applications.

HiT ODBC/DB2 supports full SQL functionality for maximum application performance including stored procedures, multiple result sets, static SQL/packages, multi-threading support. ODBC level 3 compliance offers developers powerful new data access techniques, catalog functionality, access to environmental attributes, extended data types, SQL batch support, error reporting, and ANSI SQL-92 alignment.

HiT ODBC/DB2 can be used with all major application development tools that support the Windows ODBC standard. Additionally, hundreds of third-party software products can use HiT ODBC/DB2 for business intelligence, decision support, query/reporting, data replication, and data mining. Support is also included for the most common DB2 server single and double character sets. Web/application server developers should review HiT ODBC Server/DB2 Developer Edition for these environments.

A Developer Edition of HiT ODBC/DB2 is available and includes a Visual Basic toolkit with sample project/forms demonstrating working source code that connects, queries, retrieves, and updates DB2 data over ADO, RDO, DAO and ODBCDirect.

HiT Workshop, included in the HiT ODBC/DB2 Developer Edition, includes tracing and debug tools that allow developers to examine and modify SQL execution. Also included is an ActiveX control for Visual Basic developers that provides developers with a simpler, fast interface to DB2 data.

For deployment support, silent installation support allows the middleware to be installed by calling developer setup applications. Also, included diagnostic utilities give network administrators tools to resolve configuration issues.

HiT ODBC/DB2 includes extensive on-line documentation covering ODBC data source configurations, ODBC functions, SQL grammer, using DB2 stored procedures, static SQL/package use, tracing, debugging, and diagnostics.

HiT ODBC/DB2 supports the following database standards: ODBC core and level 3 conformance, ANSI SQL-92, X/Open and ISO CLI catalog function column name standards, DRDA level 4, ADO, RDO, DAO, and ODBCDirect.

HiT ODBC/DB2 supports multiple connectivity transports to DB2 servers including TCP/IP and SNA/APPC.

Key Features			Benefits
ODBC level 3.x conformance 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 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 HiT ODBC/DB2 Developer Edition			Development time reduced

 
System Requirements:
 
Installation
· Windows Vista (32/64 bit)/XP/2000
 
OS/390
· DB2 UDB v5 or later
 
MVS Requirements
· DB2 for MVS v2.3 or later
· MVA/XA or MVA/ESA
· VTAM® 3.3 or later
 
VM Requirements
· SQL/DS® v3.4 or later
· VM/SP Release 6 or
· VM/ESA Release 1
· 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