Open System Services Programmer's Guide

appropriate to your programming language; you can even partially automate that action by
including an entry for the action in a make file. For example, the following make file entry:
zspi.h: /G/system/zspidef/zspic
cp /G/system/zspidef/zspic ./zspi.h
creates a dependency on the presence of the necessary file in the user’s local directory and makes
sure that any updates made to the Guardian copy of the file also appear in the copy used to
compile the application. Adding an include statement to the C program source code completes
the task of providing access to the SPI features.
Alternatively, you could request that your system administrators create a zspidef directory
within/usr/include and copy the necessary files from the Guardian file system into that directory
each time updates are installed on the system.
For more information about SPI, refer to the SPI Programming Manual and the SPI Common
Extensions Manual.
HP NonStop SQL/MP
The HP NonStop SQL/MP relational database management system uses the standard Structured
Query Language (SQL) to describe and manipulate data. SQL/MP can be used for online transaction
processing, decision support systems, scalable electronic commerce applications, and other business
applications.
You can access SQL databases from an OSS program as you do from a Guardian program, using
embedded SQL statements. You can also get information about SQL objects, catalogs, and programs
using Guardian procedure calls. However, in the Guardian environment, you must use several
products to compile, link, and optimize a program. In the OSS environment, you can use the c89
(but not the c99) utility to perform all of these functions in a single c89 command.
You do need to invoke the SQL compiler as well as the C compiler in the c89 command, and the
SQL compiler must be version 315 or newer. For information about the c89 utility, see the c89(1)
reference page either online or in the Open System Services Shell and Utilities Reference Manual.
For more information about writing OSS application programs that access SQL/MP databases,
see the SQL/MP Programming Manual for C.
HP NonStop SQL/MX
The HP NonStop SQL/MX relational database management system uses the standard Structured
Query Language (SQL) to describe and manipulate data. SQL/MX can be used for online transaction
processing, decision support systems, scalable electronic commerce applications, and other business
applications.
You can access SQL databases from an OSS program using embedded SQL statements. You can
also get information about SQL objects, catalogs, and programs. You can use the c89 or the c99
utility to compile, link, and optimize a program in a single c89 or c99 command.
You do need to invoke the SQL/MX compiler as well as the C compiler in the c89 or the c99
command. For information about the c89 utility, see the c89(1) reference page either online or
in the Open System Services Shell and Utilities Reference Manual. For information about the c99
utility, see the c99(1) reference page either online or in the Open System Services Shell and
Utilities Reference Manual.
For more information about writing OSS application programs that access SQL/MX databases,
see the SQL/MX Programming Manual for C and COBOL.
246 Using Subsystems From OSS