SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
6-29
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. NonStop 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. NonStop SQL/MX is unable to prepare the query.
Recovery. Correct the syntax and resubmit.
SQL 4114
Cause. You specified an absolute sample size with a scale greater than zero, which is
not supported.
Effect. NonStop SQL/MX is unable to prepare the query.
Recovery. Correct the syntax and resubmit.
SQL 4115
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. NonStop SQL/MX is unable to prepare the query.
Recovery. Correct the syntax and resubmit.
4112 Absolute and relative sampling cannot occur in the same
BALANCE expression.
4113 The sample size for type Sampling must be size type.
4114 An absolute sample size must have a scale of zero.
4115 The sample size must be less than or equal to the
sample period.