SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
6-43
SQL 4183
Cause. You attempted to perform an embedded DELETE statement on a table with a
referential constraint.
Effect. The operation fails.
Recovery. Modify the statement and resubmit.
SQL 4184
Cause. You attempted to perform an embedded UPDATE statement on columns that
are part of a referential constraint.
Effect. The operation fails.
Recovery. Modify the statement and resubmit.
SQL 4193
Where volatile-schema-prefix is a reserved schema prefix used internally to
manage volatile tables.
Cause. The volatile schema managed by the system uses a reserved schema prefix.
This prefix is a reserved word and cannot be used in an SQL statement.
Effect. None.
Recovery. Change the schema name provided as part of the two-part name to
anything other than volatile-schema-prefix and reissue the SQL statement.
SQL 4195
Cause. The GROUP BY expression contains a renamed column in the select list.
Effect. The statement does not compile.
Recovery. Correct the column name in the GROUP BY expression.
4183 Embedded DELETE statements are not allowed on referenced
tables.
4184 Columns that are part of a referential constraint cannot
be updated using embedded UPDATE statements.
4193 The schema name prefix volatile-schema-prefix is
reserved and cannot be used.
4195 The name, $0~string0, specified in the GROUP BY or
HAVING clause is ambiguous.