Interoperability with IBM Host Systems
Interoperability with IBM Host Systems |
|
SNA Server lets applications designed to use the Open Database Connectivity (ODBC) interface and Structured Query Language (SQL) commands access host databases. Using the ODBC Driver for DB2, ODBC-enabled applications can be used to access and manipulate databases on a host system that uses the Distributed Relational Database Architecture (DRDA) protocol to manage distributed data without requiring a host-based database gateway. Drivers are provided for Windows NT, Windows 2000, Windows 95, Windows 98, and Windows 3.x. SNA Server–based clients are installed during the client setup process.
Figure 10.28 depicts host data access using the ODBC Driver for DB2.
Figure 10.28 Host Data Access Using the ODBC Driver for DB2
The ODBC Driver operates by translating commands between the SQL and DRDA systems as shown in Figure 10.28. Each driver accepts SQL requests from a client application through ODBC, translates them to DRDA commands, and then sends them to the host system. The host processes the DRDA commands and returns the results to the driver on the client computer through SNA Server. The driver then converts the DRDA information to SQL data and passes the data back to the client application using the ODBC interface.
The ODBC Driver supports the following features:
The driver also supports the ability to pass SQL strings directly to the host database with translation. Supported database systems include:
For information about specific ODBC functions and data types supported by the ODBC Driver, see the SNA Server version 4.0 online documentation.
