Neoview Messages Manual (Volume 1) (R2.5)

Cause A MIN/MAX window function that has UNBOUNDED FOLLOWING in its frame
clause is used in the same query with RANK, DENSE_RANK, ROW_NUMBER or other
MIN/MAX window functions that have UNBOUNDED PRECEDING in their frame clause on
one end of the window frame and bounded PRECEDING or FOLLOWING on the other end.
Effect The operation fails.
Recovery Rewrite the query so that no MIN/MAX window function that has UNBOUNDED
FOLLOWING in its frame clause is used in the same query with RANK, DENSE_RANK,
ROW_NUMBER or other MIN/MAX window functions that have UNBOUNDED PRECEDING
in their frame clause on one end of the window frame and bounded PRECEDING or
FOLLOWING on the other end.
SQL 4350
4350 Invalid operation on view $0~Tablename: Long Running Updates are
not supported on views.
view-name
name of view on which the LRU was attempted.
Cause You attempted an LRU update operation on a view.
Effect The statement fails to execute.
Recovery Rewrite the statement to use an LRU delete on a base table or use a regular delete
on the view.
SQL 4351
4351 Set Transaction MULTI COMMIT option is only supported for DELETE
statements.
Cause MULTI COMMIT was specified on a statement other than DELETE.
Effect The statement fails to execute.
Recovery Use MULTI COMMIT ON with DELETE statement only.
SQL 4352
4352 SET TRANSACTION MULTI COMMIT ON is not compatible with the following
options: a) READ UNCOMMITTED isolation level, b) READ ONLY access mode,
and c) NO ROLLBACK ON option.
Cause You attempted to enable the MULTI COMMIT transaction option while isolation level
READ UNCOMMITTED, access mode READ ONLY or NO ROLLBACK transaction option
is enabled.
Effect The statement fails to execute and the transaction options do not take affect.
Recovery Check the transaction setting and disable the offending option.
SQL 4360
4360 Using sequence by and qualify clauses together in the same query
scope is not supported.
Cause The SEQUENCE BY clause and the QUALIFY clause were specified together in the
same query scope.
Effect The operation fails.
Recovery Rewrite the query to use either the SEQUENCE BY clause or the QUALIFY clause,
but not both.
SQL 4361
4361 All rank functions need to have the same expression as argument.
167