HP 3000 Manuals

Types of Messages [ ALLBASE/SQL Message Manual ] MPE/iX 5.5 Documentation


ALLBASE/SQL Message Manual

Types of Messages 

This manual documents two basic types of messages:

   *   Warning messages
   *   Error messages

Warning Messages 

Warning messages are followed by DBWARN and a number enclosed in
parentheses.  For example:

     Output will be truncated.  (DBWARN 1)

Warnings do not cause your program or command to be aborted, but the
entire command or the incorrect part of the command is either ignored by
ALLBASE/SQL or modified by ALLBASE/SQL so that command processing may
continue.  In some cases, the transaction may be completed in a way other
than intended and will need to be corrected.  In other cases, warning
messages are informational in nature and thus require no action to be
taken.  This manual will inform the user whether action needs to be taken
or not.

Error Messages 

Error messages are followed by DBERR and a number enclosed in
parentheses.  For example:

     Number of copies must be in the range 1..20.  (DBERR 5)

Errors are usually caused by a user's attempting to perform a command
with invalid information or without the required capability or authority.

There are three basic types of errors.  ALLBASE/SQL responds to them
differently depending on the severity of the error.

   *   The first type of error is a syntax or authority-related error
       which keeps the current command from executing.  This is the most
       common type.

   *   The second type of error causes the current transaction to be
       aborted.  In addition, a warning message is returned to inform you
       that the error was serious enough to terminate the transaction.
       For example:

            A transaction in progress was aborted.  (DBWARN 2010)

   *   The third type of error, a DBCore internal system error, is the
       least common and sometimes causes ALLBASE/SQL to be aborted.



MPE/iX 5.5 Documentation