MPE/iX Documentation Guide

Chapter 5 47

Development Tools and Distributed Computing

This manual explains the causes of warning and error conditions that may occur while

using SQL, ISQL, NETUtil, SQLUtil, SQLMigration, or their preprocessors.

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