Neoview Messages Manual (Volume 1) (R2.5)
This additional information will also be helpful: the DDL for the tables involved, the query
that produced this warning, and any CONTROL QUERY SHAPE and CONTROL QUERY
DEFAULT settings in effect when the error occurred.
SQL 2054
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'.
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
2055 The specified value 'value' for DEFAULTS attribute name is not
valid.
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
2056 The value must be a number in the range value.
Cause You specified a value outside of the allowed range value.
Effect The operation fails.
Recovery Enter a valid value and resubmit.
SQL 2057
2057 The value must be a multiple of value.
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.
SQL 2058
2058 DEFAULTS attribute name is of type data type but is being converted
to data type.
name
is the DEFAULTS attribute name.
data type
is the attribute name value.
Cause You specified a DEFAULTS attribute name value of data type, which is not
supported. The item is being converted to data type, which is supported.
Effect Because of the conversion, the actual value used might be truncated or rounded.
Recovery Specify the value using the expected type, if appropriate.
SQL 2059
2059 Errors or warnings occurred while reading values from DEFAULTS
table name.
75