SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-33
SQL 8316
Cause. You or the system aborted a user-defined transaction.
Effect. The statement fails.
Recovery. Start a new TMF transaction, and reissue the statement.
SQL 8401
Cause. Your program was corrupted.
Effect. The statement fails.
Recovery. SQL compile and run your program again. If the problem persists, report
the entire message to your service provider.
SQL 8402
Cause. An intermediate result was too large to be held in the internal buffers, or on an
INSERT or UPDATE operation, the data was too large to fit into the target buffers. An
intermediate result overflow can occur because of an arithmetic operation or an
aggregation on large data values. The arithmetic operation might be in the statement
itself or, in the case of an INSERT or UPDATE operation, in a constraint on the table.
Effect. The statement fails.
Recovery. For an intermediate result overflow, use simpler arithmetic expressions in
your statements. If aggregates are involved, exclude large values. For an INSERT or
UPDATE operation, check the data.
SQL 8403
Cause. Not all characters could fit in the target buffer.
Effect. A truncated result was put in the target.
Recovery. Check your data or data buffers (host variables). If necessary, declare
larger host variables.
8316 The statement was executed using a transaction ID of a
TMF transaction that was aborted. The error was detected for
value-1.
8401 Invalid value for a data type was encountered.
8402 Overflow occurred during arithmetic computation or
during INSERT or UPDATE of a numeric column.
8403 A character data value was truncated.