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-44
SQL 3189
Cause. You attempted to set a lock timeout on a view, which is not supported.
Effect. The operation fails.
Recovery. None.
SQL 3192
Cause. 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.
3189 Setting a lock timeout is not allowed on a view.
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.