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

UPDATE STATISTICS and Executor Sort Messages
(9200 through 10049)
HP NonStop SQL/MX Messages Manual—544518-011
11 - 6
Executor Sort Messages
Effect. The operation fails.
Recovery. Execute either a DELETE statement or a PURGEDATA command on the
table and resubmit.
SQL 9220
where,
table-name is the name of a SQL/MX table.
Cause. The user-specified sample table has either an index or a trigger or both. An
index on the sample table might prevent the use of Side-tree inserts for populating the
sample table and degrade performance. A trigger could modify the inserted data in an
undesirable way, besides degrading performance.
Effect. The operation fails.
Recovery. Drop all the indexes and triggers on the sample table and resubmit.
SQL 9221
where,
table-name is the name of a SQL/MX table.
Cause. Either the table for which the statistics have to be collected, or the user-
specified sample table, is not a SQL/MX table - it is either a SQL/MP table or some
other object such as, index or a view. The USING SAMPLE TABLE clause is supported
for SQL/MX tables only.
Effect. The operation fails.
Recovery. Specify a SQL/MX table name. For running the UPDATE STATISTICS
command on a SQL/MP table, do not use the USING SAMPLE TABLE clause.
Executor Sort Messages
SQL 10003
Cause. This error occurs when a scratch file read operation unexpectedly reaches an
EOF.
9220 Sample table table-name cannot have index or trigger on
it.
9221 The specified table table-name is not a SQL/MX table.
10003 Sort unexpectedly encountered an EOF during a read
operation.