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

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual—523730-004
6-31
This example of a nonupdatable cursor join query selects the target of the update
correctly and receives an error:
>>SELECT A.PROD_CODE, B.UPDATE_FLAG FROM EXPRODPARAMS A, MSRATES
B
+>WHERE CASE WHEN B.UPDATE_FLAG IS NULL THEN 'N' ELSE
B.UPDATE_FLAG END = 'N'
+>AND A.ACC_TYPE = B.ACC_TYPE AND A.PROD_CODE = B.PROD_CODE
+>FOR UPDATE OF UPDATE_FLAG ;
*** ERROR[4118] The cursor query expression is not updatable.
*** ERROR[8822] Unable to prepare the statement.
SQL 4120
Cause. You attempted to perform a query with an aggregate function, a GROUP BY
clause, or a DISTINCT clause. A column in the ORDER BY clause, name, is not one of
the columns explicitly selected by the query.
Effect. The operation fails.
Recovery. Correct the ORDER BY clause and resubmit.
SQL 4121
Cause. You attempted to perform a query with an aggregate function, a GROUP BY
clause, or a DISTINCT clause. A column in the ORDER BY clause, name, is not one of
the columns explicitly selected by the query.
Effect. The operation fails.
Recovery. Correct the ORDER BY clause and resubmit.
SQL 4122
Cause. You attempted to assign NULL to a NOT NULL column name.
4120 In a query with a GROUP BY, DISTINCT, or aggregate
function, each column in the ORDER BY clause must be one of
the columns explicitly SELECTed by the query. Column in
error: name.
4121 In a query with a GROUP BY, DISTINCT, or aggregate
function, each column in the ORDER BY clause must be one of
the columns explicitly SELECTed by the query. Column in
error: name. Table in scope: name.
4122 NULL cannot be assigned to NOT NULL column name.