SQL/MP Messages Manual

SQLCI Messages (10000 to 10999)
HP NonStop SQL/MP Messages Manual—427720-006
12-76
SQL 10687
Cause. You entered a command that included an unnamed parameter, and an
unnamed parameter was not allowed. An unnamed parameter can be used only in a
PREPARE command.
Effect. The command fails.
Recovery. Specify a named parameter and reissue the command. Alternatively, to use
unnamed parameters in a SELECT statement, use the PREPARE statement to prepare
the SELECT statement, and then use the EXECUTE...USING statement to execute the
SELECT statement.
SQL 10688
Cause. An AS DATE or AS TIME clause was specified for an item whose type is not
compatible with the format. These formats are valid only with numeric items with scale
= 0. The item value must be within the range 148731278400000000 through
274927291200000000. These values are the timestamps for the dates 02 JAN 0001
and 31 DEC 3999.
Effect. The command containing the invalid format is ignored.
Recovery. Correct the format and reissue the command.
SQL 10689
Cause. The column-id displayed was specified in a RESET REPORT command;
however, that column-id is not currently set by the corresponding report command.
Effect. The column-id is ignored by the RESET REPORT command.
Recovery. Informational message only; no corrective action is needed.
10687 An unnamed parameter cannot be used in this statement.
10688 AS DATE or AS TIME format specified on an incompatible
item type or on a value that is out of range.
10689 value-1 is not specified in a current value-2 command
and cannot be reset.