Availability Guide for Change Management

Making Application Subsystem Changes Online

Availability Guide for Change Management–125506

4-11

NonStop SQL/MP in the Client/Server Environment

In the client/server environment, the client (a PC, Macintosh, or workstation) accesses

NonStop SQL/MP by sending SQL statements to Tandem gateway software. The

gateway software retrieves information from the NonStop SQL/MP database, which

resides on the server (a NonStop system). End users on the client system can use local

workstation tools to format the retrieved data into usable information.

Tandem provides two gateway products that allow clients to access NonStop SQL/MP

databases:

•

NonStop Open Database Connectivity (ODBC) Server

•

Tandem Data Access Language (DAL) Server

NonStop ODBC Server

The NonStop ODBC Server allows client applications that use either the ODBC

interface or the SQL Server interface to access NonStop SQL/MP databases. ODBC is a

database connectivity standard developed by the SQL Access Group (SAG). SQL

Server is a de facto standard.

Tandem DAL Server

The Tandem DAL Server software provides NonStop SQL/MP database access for

DAL-compatible client applications. DAL is a data connectivity language and a

standard for database access.

Figure 4-3 shows a client/server implementation of NonStop SQL/MP.

Figure 4-3. NonStop SQL/MP in the Client/Server Environment

Client A

Database

driver

Server

(Tandem NonStop System)

ODBC

DAL

Data

SQL

statements

Client

(PC, Macintosh, or workstation)

NonStop

SQL/MP