HP 3000 Manuals HP 3000 Manuals
ALLBASE/XL HP SQL
Peter Kane--Information Technology Group
ALLBASE/XL HP SQL version A.01.03 is now available on MPE XL version
(A.01.10). ALLBASE/XL is the relational database offered by
Hewlett-Packard on MPE XL. It consists of a relational database core.
The interface offered with the database core is known as ALLBASE/XL HP
SQL.
DIFFERENCES
ALLBASE/XL HP SQL, in feature set, is identical to that of HP SQL/V
version B.01.00 (Release 2), but some differences exist which should be
noted.
Maximums
* ALLBASE/XL HP SQL has increased several limits from what was
previously in effect in HP SQL/V. Using some of the increased limits
will mean that the Database Environment(DBE) cannot be migrated back
to MPE V.
* The number of columns allowed in a view or a table has been increased
from 64 to 255 in ALLBASE/XL HP SQL. If the number of columns in a
table or a view for an ALLBASE/XL HP SQL DBE is larger than 64, than
the DBE cannot be migrated back to MPE V.
* The number of columns per query has been increased from 64 to 1024 in
ALLBASE/XL HP SQL. An application containing a query using more than
64 columns cannot be migrated back to MPE/V.
* The number of pages allowed for a DBEFILE0, a logfile, and for a
DBEFILE has been increased from 32,767 to 16,777,215 in ALLBASE/XL HP
SQL.
* The maximum number of transactions executing concurrently has been
raised from 192 to 240 in ALLBASE/XL HP SQL.
ALLBASE/XL HP SQL DBA Authority Differences
* DBA Authority can no longer be revoked from the DBE Creator. The DBE
Creator is the user who created the Database Environment (DBE). This
user is automatically granted DBA Authority.
* In addition, DBA Authority is no longer automatically granted to the
user MANAGER@SYS.
Differences Between ISQL/V and ISQL/XL
* The command history buffer, which stores a list of the most recently
issued commands within ISQL, has been increased in size under
ISQL/XL. ISQL/V stores the last five commands issued, while ISQL/XL
stores the last 10 commands issued.
* The command buffer, which is a workspace for storing frequently used
commands, has also been increased in size under ISQL/XL. This buffer
under ISQL/V is 1024-bytes long, while under ISQL/XL it is 2048-bytes
long.
* ISQL/XL also uses IEEE floating point format in all real number
manipulations.
SQLUTIL/XL Differences
* Two commands, STARTDBEMON and CLEANDBE, are no longer required in
ALLBASE/XL HP SQL.
* An automatic cleanup process is used in HP SQL/XL for cleanup of
aborted transactions and processes. This cleanup process is notified
whenever an abnormal termination occurs.
ADDITIONAL INFORMATION
The HP SQL/XL manual set has been updated to document the additional
software features described within this article. Please refer to the
proper manual revision for usage and syntax of each command.
More information about ALLBASE/XL HP SQL is available from the following
sources:
SOURCE PART NUMBER
ALLBASE/XL HP SQL Reference Manual (P/N 36216-90001)
ALLBASE/XL ISQL Reference Manual (P/N 36216-90004)
ALLBASE/XL HP SQL\Database Administration Guide (P/N 36216-90005)
ALLBASE/XL HP SQL COBOL (P/N 36216-90006)
Application Programming Guide
ALLBASE/XL HP SQL Pascal (P/N 36216-90007)
Application Programming Guide
ALLBASE/XL HP SQL Message Manual (P/N 36216-90009)