SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual—523730-004
6-28
To correct the query, add a SEQUENCE BY clause:
>>select runningsum(a) from t1 sequence by b;
SQL 4111
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;
*** ERROR[4111] The query contains a SEQUENCE BY clause but no
sequence functions.
*** ERROR[8822] Unable to prepare the statement.
Correct the syntax with one of these:
>>select a, runningavg(c) from T1 sequence by a;
>>select a from T1 order by a;
SQL 4112
Cause. You attempted to perform absolute and relative sampling in the same balance
expression, which is not supported.
Effect. SQL/MX is unable to prepare the query.
Recovery. Correct the syntax and resubmit.
SQL 4113
Cause. You specified an invalid combination of sample type and sample size type.
Effect. SQL/MX is unable to prepare the query.
Recovery. Correct the syntax and resubmit.
4111 The query contains a SEQUENCE BY clause but no sequence
functions.
4112 Absolute and relative sampling cannot occur in the same
BALANCE expression.
4113 The sample size for type Sampling must be size type.