 |
» |
|
|
|
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 COBOL language source code.
This manual is intended as a learning tool and a reference guide for
COBOL programmers. It presumes the reader has a working knowledge of COBOL,
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 COBOL," is an introduction to ALLBASE/SQL programming
which includes
information on developing, using, and maintaining programs on the MPE XL
operating system.
The remaining chapters focus primarily on embedding SQL commands in COBOL application programs.
Chapter 2, "Using the ALLBASE/SQL COBOL 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 COBOL 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 13 address the various ways to manipulate
data in an ALLBASE/SQL COBOL 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 operate on 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, "BULK Table Processing," examines the processing of multiple
rows at a time.
Chapter 10, "Using Dynamic Operations," covers the use of ALLBASE/SQL commands
that are preprocessed at runtime.
Chapter 11, "Programming with Constraints," discusses ways to ensure the
integrity of your data.
Chapter 12, "Programming with LONG Columns," shows how to use columns much
longer than regular columns.
Chapter 13, "Programming with ALLBASE/SQL Functions," describes ALLBASE/SQL functions, including date/time functions and Tuple Identification (TID) functions.
Chapters 2, 3, 5, 7 through 10, and chapter 13 contain sample programs for use with
the sample database.
|
