MPE/iX Documentation Guide (32650-90896)
40 Chapter5
Development Tools and Distributed Computing
Development Tools and Distributed Computing
This manual contains information on the following topics:
• Types of messages and how they are returned.
• ALLBASE/SQL error messages.
ALLBASE/SQL Pascal Application Programming Guide
Part Number: 36216-90082
Functional Focus: ALLBASE Pascal application programming
This guide describes how to write a Pascal program that accesses an HP SQL
DBEnvironment.
This guide contains information on the following topics:
• Understanding and using the HP SQL Pascal preprocessor and programs.
• Embedding HP SQL commands.
• Using and declaring host variables.
• Run-time status checking and data manipulation.
• Sequential and BULK table processing.
• Dynamic operations and programming for performance.
ALLBASE/SQL Performance and Monitoring Guidelines
Part Number: 36216-90103
Functional Focus: ALLBASE database administration
This guide describes how to improve the performance of your ALLBASE/SQL database.
This guide contains information on the following topics:
• Improving performance through logical and physical data design.
• Writing queries and transactions for best performance.
• Administering the database for best performance.
• Tuning your operating system for best performance with ALLBASE/SQL.
• Troubleshooting performance problems with SQLMON, an online tool for monitoring
the activity of a DBEnvironment.
• Using the SQLMON screens and commands.
ALLBASE/SQL Reference Manual
Part Number: 36216-90216
Functional Focus: ALLBASE database creation, maintenance, and programming
This manual presents the syntax and semantics of SQL, the language used to define,
access, and maintain data in an ALLBASE/SQL database.