MPE/iX Documentation Guide (32650-90896)

40 Chapter5

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 deﬁne,

access, and maintain data in an ALLBASE/SQL database.