SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

UPDATE STATISTICS Messages (9200 through
9225)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
11-4
SQL 9212
Cause. The SET ROWCOUNT option was not used in the SAMPLE clause.
Effect. Processing continues without interruption.
Recovery. Provide SET ROWCOUNT option and resubmit for more accurate
statistics.
SQL 9213
Cause. You attempted to perform UPDATE STATISTICS and did not specify a column
list.
Effect. Processing continues without interruption.
Recovery. Correct your syntax to specify the column list and resubmit.
SQL 9214
Cause. UPDATE STATISTICS encountered an error during a CREATE of the object
name.
Effect. NonStop SQL/MX is unable to continue processing.
Recovery. Resubmit the statement. If this does not correct the problem, stop and
restart NonStop SQL/MX. If this does not correct the problem, report the entire
message to your service provider.
SQL 9215
Cause. UPDATE STATISTICS received an internal error at the location with error
code errorcode implying otherdetails.
Effect. The operation fails.
Recovery. Do not attempt recovery. Contact your service provider.
9212 Cardinality statistics will be more accurate if you use
the SET ROWCOUNT option in the SAMPLE clause.
9213 If you intend to update histogram statistics for
columns, you must specify a column list in the statement.
9214 Object name could not be created.
9215 UPDATE STATISTICS encountered an internal error (from
location with return value=errorcode). Details:
otherdetails.