SQL/MP Messages Manual

Message Handling
HP NonStop SQL/MP Messages Manual—427720-006
1-4
Interactive Recovery Information
Interactive Recovery Information
When you submit SQL queries and other statements through SQLCI, the interface
returns error numbers as necessary. To view error information, enter the ERROR
command with an error number. SQLCI displays the error text associated with the
specified error.
This example lists output from an ERROR command that requests information for error
100:
>>error 100;
**** File System ERROR 100
device not ready or controller not operational
**** SQL ERROR 100
No rows selected or modified.
CAUSE:
For a fetch operation, the fetch is at end-of-file or
no rows qualified. For a delete or update operation,
no rows are modified.
EFFECT:
No rows qualified for the operation.
RECOVERY:
Check that you are positioned correctly in the file
and that you specify the rows correctly.
**** SORT ERROR 100
SORTPROG must be SQL licensed.
>>
Error recovery varies according to the type of work you are performing. For example, if
you receive an error that indicates you specified an invalid table name in an SQL
statement, one of these procedures could apply:
•
For a static SQL statement:
1. Correct the table name in the statement.
2. Execute the statement again.
•
For a dynamic SQL statement:
1. Correct the statement.
2. Use the PREPARE statement to compile the dynamic statement.
3. Execute the statement again.