ALLBASE/SQL Message Manual (36216-90213)

Chapter 1 11
Introduction
How Messages are Returned
How Messages are Returned
Depending on the way you are using ALLBASE/SQL, messages will be returned in one of
the following ways:
• When you use ISQL, SQLUtil, SQLAudit, SQLGEN, SQLMigrate, SQLMON,
ALLBASE/NET, or NETUtil interactively, messages are returned to the standard
output, which is typically the terminal screen. These messages appear immediately
after ALLBASE/SQL encounters a problem. When using ISQL, SQLUtil, SQLAudit,
SQLGEN, SQLMigrate, SQLMON, NET, or NETUtil in background, messages are
returned to the standard output after processing.
• When an error occurs during execution of an ISQL command file, one of two things will
occur. If SET CONTINUE is ON, the error message is displayed on the screen and the
subsequent commands are executed. If SET CONTINUE is OFF, a message is returned
to the terminal screen and none of the subsequent commands are executed. Refer to the
ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL for additional
information on the CONTINUE option of the SET command.
• When you use the preprocessors, errors and warnings are returned to a temporary file
with the formal file designator SQLMSG. A module is not stored when an error is
encountered, and your source code needs to be corrected before re-preprocessing. For
additional information, refer to the ALLBASE/SQL application programming guide for
the language you are using.
• An application program that contains embedded SQL commands must include error
handling routines to return runtime errors using the SQLEXPLAIN command. For
additional information on SQLEXPLAIN, refer to the ALLBASE/SQL application
programming guide for the language you are using.
While some messages will be self-explanatory, others will require additional information
which can be obtained from this manual, other ALLBASE/SQL manuals, or the ISQL,
SQLUtil, SQLAudit, SQLGEN, SQLMigrate, SQLMON, or NETUtil HELP command.