SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-40
SQL 8429
Cause. The DST Transition Table was not updated with this date-time value.
Effect. The input value is rejected and the statement fails.
Recovery. Update the DST Transition Table with an entry covering this date-time
value. The DST Transition Table can be updated by the super ID using the
ADDDSTTRANSITION procedure. For more information on this procedure, refer to the
Guardian Procedure Calls Reference Manual.
SQL 8430
Cause. The POSITION function requires a positive integer for its occurrence operand.
The SUBSTRING function requires a positive integer for its substring length operand.
Effect. The operation fails.
Recovery. Correct the operand, and reissue the request.
SQL 8431
Cause. The length of the trim character operand was not 1.
Effect. The operation fails.
Recovery. Change the operand so its length equals 1 and reissue the request.
SQL 8500
Cause. The statement PREPARE:P.:S... creates a different SQL procedure for each
distinct value supplied in the host variable P. Too many such values have been used.
Effect. The PREPARE statement fails.
Recovery. Reduce the number of SQL procedures used in the program.
8429 No entry is available in the DST Transition Table for
the entered date-time value.
8430 An invalid operand has been specified for a string
function.
8431 The TRIM function requires a character string of length
1 for its trim character operand.
8500 Too many "SQL procedures" have been created using a
PREPARE statement.