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-30
SQL 4116
Cause. You specified an invalid operand for the second operand of function name. For
example, a numeric literal operand (for example, 9999999999999999999) cannot be
represented as a valid compile-time constant value.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit. In this example, you would replace the
numeric literal with a smaller numeric literal operand that can be represented as a valid
compile-time constant value.
SQL 4117
Cause. You specified a join or a nonupdatable query in an updatable cursor query
(that is, one with an optional FOR UPDATE OF clause). That cursor's select list did not
select the target column of the update.
Effect. The operation fails.
Recovery. An updatable cursor query should specify the target update column in the
select list of the query. Use the FOR UPDATE OF clause only if the cursor query is
updatable.
This example of a nonupdatable cursor join query does not select the target of the
update and receives an error:
>>SELECT A.PROD_CODE 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[4001] Column UPDATE_FLAG is not found. Tables in
scope: A. Default schema: CAT.SCH.
*** ERROR[4117] The cursor query expression may be nonupdatable.
*** ERROR[8822] Unable to prepare the statement.
4116 The second operand of function name is not valid.
4117 The cursor query expression might be nonupdatable.