SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
E-5
Examples—ERROR
type
specifies the type of error and can be one of these:
If you omit type, SQLCI displays the error text for all operations that generate the
specified error number.
number
is a positive or negative number that identifies the error you want described. If you
omit number, SQLCI displays information about the most recent error. The
DISPLAY_ERROR and WARNINGS session options determine which errors are
reported. For more information, see SET SESSION Command on page S-39.
DETAIL or BRIEF
specifies the error information to display.
The default is DETAIL unless you have previously set the ERROR_TEXT session
option to BRIEF. For more information, see SET SESSION Command
on
page S-39.
Examples—ERROR

This example displays the error text of file-system error number 1066:
>> ERROR FS 1066, BRIEF;
Internal error: Occurred in OPEN.
>>

This example displays the text, cause, and effect of SQL error number 1249:
>> ERROR SQL 1249, DETAIL;
A column cannot be added to an entry-sequenced table.
Cause:
Stated in the error message.
Effect:
The statement fails.
AUD Audit-fixup process
DP Disk process
FS File system
OS Guardian operating system
SIO Sequential I/O
SQL SQL command
SORT Sort
DETAIL Display error text, cause, and effect, plus suggestions for recovery.
BRIEF Display error text only.