 |
» |
|
|
|
ALLBASE/SQL is a relational database management system for use on HP
Series 300, 400, 700, and 800
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.
When Series 300 and 400 implementation differs from that of Series 700 and 800,
Series 700 and 800 information is given in the body of the text, followed by
a note in this format:
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 HP-UX operating system,
and ALLBASE/SQL relational database concepts.
This manual contains both basic and in-depth information about
embedding ALLBASE/SQL. Topics are discussed in separate chapters, as follows:
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 HP-UX 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 functions, including date/time functions
and the TID function.
Most of the examples are based on the tables, views, and other objects in the
sample database, PartsDBE. For complete information about PartsDBE, refer to
the ALLBASE/SQL Reference Manual, appendix C.
|