|
HiT ODBC/400
HiT ODBC/400 Developer Edition
HIGH PERFORMANCE ODBC DRIVER FOR IBM
DB2 ACCESS
HiT ODBC/400 (for ODBC System i, ODBC iSeries or ODBC AS/400) is Windows SQL middleware for access to IBM DB2 servers running on
System i, iSeries and AS/400 platforms. HiT ODBC/400 runs on Windows XP/2000/98 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 iSeries or AS/400 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 (for ODBC iSeries or ODBC AS/400) uses native IBM OS/400 server programs and does not require
any additional software running on the iSeries or AS/400 platforms.
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 DB2/400 server.
HiT ODBC/400 includes extensive on-line documentation covering ODBC data source
configurations, ODBC functions, SQL grammar, using DB2/400 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 DB2/400 password expiration security. A
read-only version driver is included for DB2/400 query-only client applications.
Developer Edition
In addition of the features supported by HiT ODBC/400, the developer edition 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.
| 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/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 |
|
VB toolkit with HiT ODBC/400
Developer Edition
|
|
|
Development time reduced
|
|
System Requirements:
Installation
· Windows Vista(32/64 bit)/XP/2000
· Microsoft Data Access Components (MDAC) v2.1 or later
Connectivity
· TCP/IP
· NetManage NS/Router
· Microsoft SNA Server
· IBM Client Access
· IBM Personal Communications
· Wall Data RUMBA
· Attachmate APPC Client
· WRQ Reflection
Platform
· OS/400 V3R1 through IBM i 6.1 (i5/OS V6R1)
| 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 |
|
| 
