Introduction to Data Management

Accessing Databases With NonStop SQL

3-18 15873 Tandem Computers Incorporated

In your programs, you often use the same data management statements that business

professionals and end users enter from their terminals and workstations when making

ad hoc queries or requesting printed reports. In addition, you use statements that

control access to tables and views, and other statements that establish and control

TMF transactions.

Figure 3-9. Programming with NonStop SQL

S8020-013

SQLCI

SELECT JOBCODE, NAME, SALARY/12

FROM EMPLOYEE

ORDER BY JOBCODE, NAME;

Application

Programme

PATHMAKER

../IN MYSRCE / MYPROG

Host Language

Compiler

SQLCOMP / IN MYPROG /

SQL

Compiler

EXEC SQL

DECLARE SALARY_BONUS CURSOR FOR

SELECT JOBCODE, NAME, SALARY/12

FROM EMPLOYEE

ORDER BY JOBCODE, NAME

END-EXEC

SQL

Executor

Test

Data

Dictionary

Source

Programs

Object

Program

Data

Dictionary

Business

Data

Dictionary