Neoview Messages Manual (R2.2)

SQL 4109
4109 Sequence functions are placed incorrectly: name.
Cause You specified a query that includes a SEQUENCE BY clause that contains an illegally
placed sequence function name. Sequence functions (such as RUNNINGSUM, MOVINGSUM,
LASTNOTNULL) are supported only in the select list or the HAVING clause of the query
expression containing the SEQUENCE BY clause. For example, these queries are legal:
>>select a, runningcount(b) from T1 sequence by a;
>>select x from (select a, runningcount(b)from T1 sequence by a)
T2(x,y) where y > 10;
>>select count(*) from t1 sequence by b group by a having
runningsum(a) > count(*);
Effect The operation fails.
Recovery Correct the syntax and resubmit. For example:
>>select a from T1 where runningcount(b) > 10 sequence by a;
*** ERROR[4109] Sequence functions placed incorrectly:
RUNNINGCOUNT(CAT.SCH.HPPARTEST1.B).
*** ERROR[8822] Unable to prepare the statement.
SQL 4110
4110 The query contains sequence functions but no SEQUENCE BY clause:
name.
Cause You specified a query that contains a sequence function name but no SEQUENCE
BY clause, which is not supported. The value of the sequence function depends on the specific
sequence (order) of the rows. If no sequence is defined, the result of the sequence function is
dependent on an arbitrary ordering of the rows, which could lead to unexpected results.
Effect The operation fails.
Recovery Correct the syntax and resubmit. For example:
>>select runningsum(a) from t1;
*** ERROR[4110] The query contains sequence functions but no
SEQUENCE BY clause: RUNNINGSUM(CAT.SCH.T1.A).
To correct the query, add a SEQUENCE BY clause:
>>select runningsum(a) from t1 sequence by b;
SQL 4111
4111 The query contains a SEQUENCE BY clause but no sequence functions.
Cause You specified a query that contained a SEQUENCE BY clause but no sequence
functions, which is not supported. The purpose of the SEQUENCE BY clause is to specify an
ordering for computing one or more sequence functions. Without sequence functions, the
SEQUENCE BY clause has no effect.
Effect The operation fails.
Recovery Correct the syntax by adding a sequence function to the query or by using an
ORDER BY (if you intend to order the result set.) For example:
>>select a from T1 sequence by a;
141