 |
» |
|
|
|
ALLBASE/SQL is a relational database management system for use on HP
3000 Series
900
computers. ALLBASE/SQL (Structured Query Language) is the
language you use to define and maintain data in an ALLBASE/SQL
DBEnvironment. This manual presents the techniques of embedding
ALLBASE/SQL within FORTRAN language source code.
This manual is intended as a learning tool and a reference guide
for FORTRAN programmers. It presumes the reader has a working
knowledge of FORTRAN,
the MPE/iX operating system,
and ALLBASE/SQL relational database concepts.
MPE/iX, Multiprogramming Executive with Integrated POSIX, is the latest
in a series of forward-compatible operating systems for the HP 3000
line of computers.
In HP documentation and in talking with HP 3000 users, you will
encounter references to MPE XL, the direct predecessor of MPE/iX.
MPE/iX is a superset of MPE XL. All programs written for MPE XL
will run without change under MPE/iX. You can continue to use MPE XL
system documentation, although it may not refer to features added to
the operating system to support POSIX (for example, hierarchical
directories).
This manual contains both basic and in-depth information about
embedding ALLBASE/SQL. Code examples are based, for the most
part, on the sample database, PartsDBE, which accompanies
ALLBASE/SQL. Refer to Appendix C in the ALLBASE/SQL Reference Manual for information
about the structure of PartsDBE and for listings of the sample
database.
Chapter 1, "Getting Started with ALLBASE/SQL Programming in FORTRAN," is an introduction to ALLBASE/SQL
programming which includes information on developing, using, and
maintaining programs on the
MPE/iX operating system.
Chapter 2, "Using the ALLBASE/SQL FORTRAN Preprocessor,"
explains the ALLBASE/SQL preprocessor and how to invoke it.
Chapter 3, "Embedding SQL Commands," gives rules on where and
how to embed SQL commands.
Chapter 4, "Host Variables," describes how to define and use
variables to transfer data between your FORTRAN program and an
ALLBASE/SQL DBEnvironment.
Chapter 5, "Runtime Status Checking and the SQLCA," defines ways to monitor
and handle successful and unsuccessful SQL command execution.
Chapters 6 through 12 address the various ways to manipulate data
in an ALLBASE/SQL FORTRAN program.
Chapter 6, "Overview of Data Manipulation," is an overview of
data manipulation and the techniques for executing data
manipulation commands.
Chapter 7, "Simple Data Manipulation," explains how to process
data one row at a time.
Chapter 8, "Processing with Cursors," explains the use of a
cursor to process a multiple row query result one row at a time.
Chapter 9, "Using Dynamic Operations," covers the use of ALLBASE/SQL
commands that are preprocessed at runtime.
Chapter 10, "Programming with Constraints," describes ALLBASE/SQL data integrity features and describes
how to use them in programs.
Chapter 11, "Programming with LONG Columns," describes how to program with LONG columns.
Chapter 12, "Programming with ALLBASE/SQL Functions," contains descriptions of SQL, including date/time functions
and the TID function.
Chapters 2, 3, 5, and 7 through 9 contain sample programs for
use with the sample database.
|
