Introduction to Data Management

Accessing Databases With NonStop SQL

3-20 15873 Tandem Computers Incorporated

Figure 3-11. NonStop SQL Server in a PATHWAY Environment

S8020-01

• • •

Display

Screens

Requester

Server

Commands

and Data

Return

Replies

Select

Data

Send

Requests

Update

Data

Dictionary

Business

Data

Table or View

In working with the overall application, you will generally use the following software:

SQLCI to build application prototypes and to test SQL statements before

embedding them in your program, and to define and process formatted reports

PATHMAKER to generate the requesters and servers for execution in a

PATHWAY operating environment

SQL statements embedded in servers to retrieve and modify data in your database

For your host language, the corresponding compiler to compile the host-language

source code into object code

The NonStop SQL compiler to compile the embedded SQL code, to generate a

single, easy-to-manage object file containing compiled host-language and SQL

code, and to register the program in the database dictionary

Additional Programmatic Advantages

One advantage of programmatic NonStop SQL is that it supports automatic data

declarations. With this feature, a single statement or directive translates selected data

definitions from the NonStop SQL dictionary into host-language data declaration

code. This step ensures that the program works with the most current dictionary

definitions. Thus, you need not rewrite your data declarations if the database

changes; you simply recompile your program to obtain any new definitions from the

dictionary.