HP NonStop SQL/MX - Page 175

Parser and Compilation Messages (3000 through
3999)
HP NonStop SQL/MX Messages Manual—640324-001
5-45
SQL 3192
Cause. NonStop SQL/MX attempted to compile a UNION query that has an
access/lock mode that can be applied to both branches of the access/lock mode or
only to the second branch of the UNION.
Effect. The access/lock mode is applied only to the second branch of the UNION.
Recovery. Specify that the access/lock mode apply to both branches and resubmit.
SQL 3193
Where string is the SIGNAL SQLSTATE value.
Where string1 is the SIGNAL text message.
Cause. You attempted a SIGNAL statement. SIGNAL statements are commonly used
as an action for a trigger in a compound statement or in a user application.
Effect. The operation fails.
Recovery. None.
SQL 3195
Where dtype is a data type specified for a column.
Cause. The data type specified for a column in a CREATE TABLE statement is not
supported.
Effect. The operation fails.
Recovery. Correct the data and resubmit.
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.
3192 Union operands table1 and table2 have different
access/lock modes.
3193 SIGNAL SQLSTATE= string, message: string1.
3195 Table creation with data type dtype is not supported.
3196 Only one access clause for may be specified for a single
table SELECT.