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-34
SQL 3145
Cause. You attempted to perform a positioned UPDATE or DELETE, which is
supported only in embedded SQL/MX.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 3147
Cause. You specified an IN predicate whose right operand is a value list but whose
left operand is not scalar, which is required.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 3148
Where value is the environment variable value specified.
Cause. SQL/MX is ignoring the environment variable you specified. Query results
might not match expected results.
Effect. None.
Recovery. Informational message only; no corrective action is needed.
SQL 3149
Cause. The WITH CONSTRAINTS phrase appears multiple times within the LIKE
clause of the CREATE TABLE statement, which is not supported.
Effect. The operation fails.
Recovery. Remove the duplicate WITH CONSTRAINTS phrases.
3145 Positioned UPDATE or DELETE is allowed only in embedded
SQL.
3147 In an IN predicate whose right operand is a value list,
the left operand must be scalar (degree of one).
3148 Environment variable value is being ignored because this
version of the code is Release, not Debug. Actual query
results will likely not match expected results.
3149 Duplicate WITH CONSTRAINTS phrases were specified in
LIKE clause in CREATE TABLE statement.