 |
» |
|
|
|
This manual presents the syntax and semantics of SQL (Structured Query
Language) on HP 3000 computers running under
the MPE/iX operating system. ALLBASE/SQL is Hewlett-Packard's
proprietary relational database management product.
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 basic information about ALLBASE/SQL
as well as in-depth information about ALLBASE/SQL
data types and statements. The first three chapters are for all readers, including new users of ALLBASE/SQL. The remaining chapters are for experienced SQL
users and SQL application programmers.
The titles of the chapters are as follows: Chapter 1, "Introduction," presents the components of ALLBASE/SQL and
introduces fundamental ALLBASE/SQL concepts and terms.
Chapter 2, "Using ALLBASE/SQL," describes basic ALLBASE/SQL usage rules.
Chapter 3, "SQL Queries," presents a full treatment of
queries, including the use of subqueries, UNION, and special predicates.
Chapter 4, "Constraints, Procedures and Rules," presents data objects
which provide a high degree of data consistency and integrity inside
the DBEnvironment.
Chapter 5, "Concurrency Control through Locks and Isolation Levels,"
describes ways of managing concurrent database transactions.
Chapter 6, "Names," presents general rules for names used in
ALLBASE/SQL statements.
Chapter 7, "Data Types," details the data types available in ALLBASE/SQL.
Chapter 8, "Expressions," describes ALLBASE/SQL expressions.
Chapter 9, "Search Conditions," presents the basic syntax of
ALLBASE/SQL predicates.
Chapter 10, "SQL Statements," contains an alphabetical reference of all
the SQL statements and other elements of syntax.
The appendixes contain additional reference information as follows: Appendix A, "SQL Syntax Summary," contains an alphabetical summary of
all ALLBASE/SQL
statements and other elements of syntax.
Appendix B, "ISQL Syntax Summary," contains an alphabetical summary
of all ALLBASE/ISQL commands.
Appendix C, "Sample DBEnvironment," describes the sample
DBEnvironment, PartsDBE, which is supplied with the product. An
explanation is provided of how to install, and set up a copy of
PartsDBE for practice use.
Appendix D, "Standards Flagging Support," contains information
about ALLBASE/SQL FIPS 127.1 compliance.
Most of the examples in this manual are based on the tables,
views, and other objects in the sample DBEnvironment PartsDBE.
For complete information about PartsDBE, refer to
appendix C.
|
