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-29
SQL 4114
Cause. You specified an absolute sample size with a scale greater than zero, which is
not supported.
Effect. 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. SQL/MX is unable to prepare the query.
Recovery. Correct the syntax and resubmit.
SQL 4116
Cause. You specified an invalid operand for the second operand of function name. For
example, a numeric literal operand (for example, 9999999999999999999) cannot be
represented as a valid compile-time constant value.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit. In this example, you would replace the
numeric literal with a smaller numeric literal operand that can be represented as a valid
compile-time constant value.
SQL 4117
Cause. You specified a join or a nonupdatable query in an updatable cursor query
(that is, one with an optional FOR UPDATE OF clause). That cursor's select list did not
select the target column of the update.
Effect. The operation fails.
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.
4116 The second operand of function name is not valid.
4117 The cursor query expression might be nonupdatable.