 |
|
Database Connectivity for IBM i
|
Standard Edition
|
HiT ODBC/400
HiT ODBC/400 Developer Edition
HIGH PERFORMANCE ODBC DRIVER FOR IBM DB2 ACCESS
HiT ODBC/400 (for IBM i, iSeries or AS/400) is Windows SQL middleware for access to IBM DB2
servers running on IBM i, iSeries and AS/400 platforms. HiT ODBC/400 runs on Windows 7,
Windows XP, Windows Vista, Windows 98/95, Windows NT Workstations, and is used by custom
or third party product applications. It supports the Windows Open Database Connectivity (ODBC) standard to
access, retrieve, and update DB2 data. All communication with the IBM i platform can also be
optionally encrypted and authenticated via SSL with HiT SSL Server. Leveraging the IBM Optimized Database
Server (ODBS) protocol standard, HiT ODBC/400 uses native IBM OS server programs and does not require any additional software running on the IBM i platform.
Improve performance with ODBC Level 3.x
HiT ODBC/400 supports full SQL functionality (via ODBC level 3.x conformance) for maximum performance of
client applications. Functionalities include stored procedures, multiple result sets, static SQL/packages,
multi-threading and dbExpress. ODBC level 3.x conformance 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/400 is particularly useful for developers working with custom
applications. Silent installation support allows the middleware to be installed by calling custom setup
applications. HiT Toolbox, included with the run-time middleware, is a sophisticated ODBC diagnostic tool
for network administrators who need to resolve network issues. For developers, tracing and debugging tools
enable examination and modification of SQL passed to the IBM DB2 for i server.
HiT ODBC/400 includes extensive on-line documentation covering ODBC data source
configurations, ODBC functions, SQL grammar, using stored procedures, static SQL/package use,
tracing, debugging, and diagnostics.
Security
HiT ODBC/400 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 ODBC/400
and the system where HiT
SSL Server is installed.
HiT ODBC/400 also supports IBM DB2 for i password expiration security. A
read-only version driver is included for query-only client applications.
Developer Edition
In addition of the features supported by HiT ODBC/400, the developer edition includes the C# toolkit,
with sample project/forms demonstrating working source code that connects, queries, retrieves, and
updates DB2 data over ADO, and ODBCDirect.
Standard Edition
Full Support
during Trial Period |
Developer Edition
Full Support
during Trial Period |
| Key Features |
 |
|
Benefits |
|
ODBC level 3.x conformance
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 |
|
|
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 |
|
IBM 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 |
|
C# toolkit included with Developer Edition
|
|
|
Development time reduced |
|
System Requirements:
Installation
· Windows 7 (32/64-bit), Vista(32/64-bit),XP, Windows 98/95, Windows NT Workstation
· Microsoft Data Access Components (MDAC) v2.5 or higher
Connectivity
· Support for TCP/IP and APPC network protocols
· NetManage NS/Router
· Microsoft SNA Server
· IBM Client Access
· IBM Personal Communications
· Wall Data RUMBA
· Attachmate APPC Client
· WRQ Reflection
Platform
· OS/400 V3R7 or higher
| 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 |
|
|
CLOB |
|
Standard Edition
Full Support
during Trial Period |
Developer Edition
Full Support
during Trial Period |
| |
Std. Edition
View
Std. Edition
