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

Parser and Compilation Messages (3000 through
3999)
HP NonStop SQL/MX Messages Manual—523730-004
5-45
SQL 3196
Cause. You specified two or more table-level access options for the same table
reference.
Effect. The offending SQL statement is rejected with an error.
Recovery. Remove all but one of the table-level access options for each table
reference.
SQL 3197
Cause. You specified two or more table-level lock options for the same table
reference.
Effect. The offending SQL statement is rejected with an error.
Recovery. Remove all but one of the table-level access options for each table
reference.
SQL 3199
Where col-name is the name of the column.
Cause. You cannot specify ordering for columns of a partitioning key clause.
Effect. The operation fails.
Recovery. Remove any of the following keywords from the columns specified in the
PARTITION clause: ASCENDING, ASC, DESCENDING, DESC, and resubmit.
SQL 3201
Cause. In the CREATE PROCEDURE statement, you omitted the mandatory
EXTERNAL PATH clause.
Effect. The operation fails.
3196 Only one access clause for may be specified for a single
table SELECT.
3197 Only one lock clause may be specified for a single table
SELECT.
3199 Column col-name is incorrectly specified. Keywords
ASCENDING and DESCENDING are not allowed in the partitioning
key list.
3201 EXTERNAL PATH clause is required.