 |
» |
|
|
|
ALLBASE/SQL is a relational database management system for use on
the HP 3000 Series 900 computer. 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 Pascal language source code.
This manual is intended as a learning tool and a reference guide for
Pascal programmers. It presumes the reader has a working knowledge of Pascal,
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. Topics are discussed in separate chapters, as follows:
Chapter 1, "Getting Started with ALLBASE/SQL Pascal Programming,"
is an introduction to ALLBASE/SQL programming which includes
information on developing, using, and maintaining programs on the
MPE XL operating system.
Chapter 2, "Using the ALLBASE/SQL Pascal Preprocessor," explains the ALLBASE/SQL
preprocessor and how to invoke it.
Chapter 3, "Embedding SQL Commands," gives rules for how and where to
embed SQL commands.
Chapter 4, "Host Variables," describes how to define and use variables
to transfer data between your Pascal 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.
Chapter 6, "Overview of Data Manipulation," is an overview of data
manipulation and the technniques for executing data manipulation
commands.
Chapter 7, "Simple Data Manipulation," explains how to operate on
one row at a time.
Chapter 8, "Processing with Cursors," shows how
to process a multiple row query result one row at a time.
Chapter 9, "BULK Table Processing," examines the processing of multiple
rows at a time.
Chapter 10, "Using Dynamic Operations," describes the use of ALLBASE/SQL
commands that are preprocessed at runtime.
Chapter 11, "Programming with Constraints," compares the use of statement
level integrity and row level integrity and discusses the use of integrity
constraints.
Chapter 12, "Programming with LONG Columns," discusses the LONG BINARY
and LONG VARBINARY data types.
Chapter 13, "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.
|
