HP Neoview Messages, Руководство пользователя

Страница: 148 / 400

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;
*** 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
4112 Absolute and relative sampling cannot occur in the same BALANCE
expression.
Cause You attempted to perform absolute and relative sampling in the same balance
expression, which is not supported.
Effect The HP Neoview database software is unable to prepare the query.
Recovery Correct the syntax and resubmit.
SQL 4113
4113 The sample size for type Sampling must be size type.
Cause
You specified an invalid combination of sample
type
and sample
size type
.
Effect
The HP Neoview database software is unable to prepare the query.
Recovery
Correct the syntax and resubmit.
SQL 4114
4114 An absolute sample size must have a scale of zero.
Cause You specified an absolute sample size with a scale greater than zero, which is not
supported.
Effect
The HP Neoview database software is unable to prepare the query.
Recovery
Correct the syntax and resubmit.
SQL 4115
4115 The sample size must be less than or equal to the sample period.
Cause You specified a sample size that is greater than the sample period. It must be less than
or equal to the sample period.
Effect
The HP Neoview database software is unable to prepare the query.
Recovery
Correct the syntax and resubmit.
148 Binder and Compilation Messages (4000 Through 4999)