SQL/MX 2.x Messages Manual (H06.10+, J06.03+)

SQL/MX MXCMP Messages (2000 through 2999)
HP NonStop SQL/MX Messages Manual—544518-011
4-13
SQL 2054
Cause. You attempted to set the CQD HIST_NO_STATS_ROWCOUNT value as less
than the current value of CQD HIST_NO_STATS_UEC.
Effect. The current value of the HIST_NO_STATS_ROWCOUNT is retained.
Recovery. Set the value of CQD HIST_NO_STATS_ROWCOUNT greater than or
equal to the value of HIST_NO_STATS_UEC. If you want to use a smaller value,
reduce the value of CQD HIST_NO_STATS_UEC first. Note that any change in either
of the two values can have an effect on the plan quality.
SQL 2055
Cause. You specified an invalid value for the DEFAULTS attribute listed in the
message.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 2056
Cause. You specified a value outside of the allowed range value.
Effect. The operation fails.
Recovery. Enter a valid value and resubmit.
SQL 2057
Cause. You specified an invalid value for an attribute. It must be a multiple of value.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
2054 HIST_NO_STATS_ROWCOUNT should always be greater than or
equal to CQD HIST_NO_STATS_UEC. Present value of
HIST_NO_STATS_UEC is 'value'.
2055 The specified value 'value' for DEFAULTS attribute name
is not valid.
2056 The value must be a number in the range value.
2057 The value must be a multiple of value.