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-2
•
Perform UPDATE STATISTICS FOR the table. Then reexecute UPDATE
STATISTICS with the column lists in which you are interested.
SQL 9203
Cause. You specified a nonunique column name in the specified column list.
Effect. SQL/MX is unable to continue processing.
Recovery. Correct the syntax and resubmit.
SQL 9204
Cause. You specified an invalid option for UPDATE STATISTICS. The value range
specifies the valid range for this option.
Effect. SQL/MX is unable to continue processing.
Recovery. Correct the syntax and resubmit.
SQL 9205
Cause. You attempted to run UPDATE STATISTICS against an object that is not
supported.
Effect. SQL/MX is unable to continue processing.
Recovery. Correct the syntax and resubmit.
SQL 9206
Cause. SQL/MX could not perform an UPDATE STATISTICS statement because you
are not authorized to perform this operation against this table. You must either own the
object name or be the super ID.
Effect. SQL/MX is unable to continue processing.
Recovery. Resubmit after checking the table location and access privileges.
9203 Column names must be unique when specified in column
list: (name).
9204 Invalid option option specified. Value must be range.
9205 UPDATE STATISTICS is not supported for object name.
9206 You are not authorized to read/write object name. Verify
that you have the necessary access privileges.