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-25
SQL 4100
Cause. You specified a NULL value in a select list that is not cast to a data type, which
is required.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4101
Cause. A syntax error has caused NonStop SQL/MX to treat object name as an
ambiguous entity.
Effect. The operation fails.
Recovery. Check the syntax for a missing parenthesis and resubmit. If the object is
not intended as a table reference in the FROM clause, use the error messages that
accompany this one to diagnose the problem. Correct the syntax and resubmit.
SQL 4102
Cause. You attempted to use either a FIRST n or an ANY n clause in other than an
outermost SELECT statement.
Effect. The operation fails.
Recovery. Remove the FIRST n or ANY n clause and resubmit.
SQL 4103
Cause. An internal error occurred during retrieval of node numbers in SQL/MX cluster.
Effect. Service request fails and Transporter jobs may terminate.
4100 A NULL value is not allowed in a select list unless it
is CAST to some data type.
4101 If name is intended to be a further table reference in
the FROM clause, the preceding join search condition must be
enclosed in parentheses.
4102 The [FIRST/ANY n] syntax can be used only in an
outermost SELECT statement that is not contained in a UNION
or INSERT.
The [FIRST/ANY n] syntax is not allowed in query expression
of a view.