Neoview Messages Manual (R2.3)

• There are no GROUP BY, DISTINCT, or ORDER BY clauses.
• All select_list columns are column references.
• No column reference occurs more than once in the select list.
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 4119
4119 The requested number of parallel extract streams must be greater
than one and cannot exceed the number of configured CPUs, number.
number
is the number of configured Neoview processing nodes.
Cause HP Neoview database software was unable to compile a parallel extract producer
query because the number of requested streams was either too low or too high. The number
of streams must be greater than 1 and cannot exceed the number of HP Neoview processing
nodes.
Effect The operation fails.
Recovery Resubmit with an appropriate number of requested streams.
SQL 4120
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.
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
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.
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
4122 NULL cannot be assigned to NOT NULL column name.
142 Binder and Compilation Messages (4000 Through 4999)