HP 3000 Manuals HP 3000 Manuals
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.