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

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.
Cause Multiple RANK functions with different expressions were specified.
Effect The statement fails.
Recovery Rewrite the query so that it does not contain multiple RANK functions with different
expressions.
SQL 4362
4362 Using ASC/DESC with sequence functions is not supported.
Cause ASC/DESC was specified in the expression of the RANK sequence function.
Effect The statement fails to prepare.
Recovery Rewrite the query so that it does not contain ASC/DESC in the argument of the
RANK sequence function.
SQL 4363
4363 Using Qualify clause without using rank function in the query is
not allowed.
Cause The QUALIFY clause was used, but no RANK function was included in the query.
Effect The statement fails to prepare.
Recovery Rewrite the query so that the query contains the RANK function if it contains the
QUALIFY clause.
SQL 4364
4364 Rank can be placed only in the select list or the qualify clause.
Cause The RANK function can be placed only in the SELECT list or the QUALIFY clause.
Effect The statement fails to prepare.
Recovery Rewrite the query so that the RANK function is placed only in the SELECT list or
the QUALIFY clause.
SQL 4365
4365 Using rank function and aggregate functions in the same scope is
not supported.
163