SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

UPDATE STATISTICS and Executor Sort Messages
(9200 through 10049)
HP NonStop SQL/MX Messages Manual—523730-004
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. SQL/MX is unable to continue processing.
Recovery. Resubmit the statement. If this does not correct the problem, stop and
restart SQL/MX. If this does not correct the problem, report the entire message to your
service provider.
SQL 9215
Cause. UPDATE STATISTICS has received an internal error at the location
specified in the message.
Effect. The operation fails.
Recovery. Resubmit the statement. If this does not correct the problem, stop and
restart SQL/MX. If this does not correct the problem, report the entire message to 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
(location).