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

SQL 4342
4342 The specified window frame clause is not valid.
Cause The window frame clause specified was not valid.
Effect The operation fails.
Recovery Rewrite the query and use a valid window frame clause.
SQL 4343
4343 A Window Frame Clause cannot contain a FOLLOWING term, either
explicitly or implicitly.
Cause The window frame clause of a window function contains a FOLLOWING term.
Effect The operation fails.
Recovery Rewrite the query and exclude any FOLLOWING term.
SQL 4345
4345 Window and Sequence functions cannot be used together.
Cause Both the window and sequence function syntax were used together.
Effect The operation fails.
Recovery Rewrite the query to contain either a valid window frame clause or sequence
functions.
SQL 4346
4346 Window functions can be placed only in the select list.
Cause Window functions can be placed only in the select list.
Effect The operation fails.
Recovery Rewrite the query so that windows functions are placed only in the select list.
SQL 4347
4347 Maximum Window frame size of n1 rows exceeded.
n1 is the maximum number of rows.
Cause The window frame specified is larger than the maximum window frame allowed.
Effect The operation fails.
Recovery Rewrite the query so that window frame size does not exceed the maximum window
frame allowed.
SQL 4348
4348 Nesting Window functions with FOLLOWING clause is not supported.
Cause A window function that has FOLLOWING in its frame clause is nested inside another
window function.
Effect The operation fails.
Recovery Rewrite the query so that no window function with FOLLOWING in its frame
clause is nested inside another window function.
SQL 4349
4349 Using MIN/MAX window functions with UNBOUNDED FOLLOWING in their
frame clause in the same query as RANK, DENSE_RANK, ROW_NUMBER or another
MIN/MAX with UNBOUNDED PRECEDING on one end of the window frame and
bounded PRECEDING or FOLLOWING on the other end is not supported.
166 Binder and Compilation Messages (4000 Through 4999)