HP NonStop SQL/MX, Messages Manual

Page: 218 / 752

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual —640324-001
6- 32
SQL 4120
Cause. You attempted to perform a query with an aggregate function, a GROUP BY
clause, or a DISTINCT clause. A column in the ORDER BY clause,
name
, is not one of
the columns explicitly selected by the query.
Effect. The operation fails.
Recovery. Correct the ORDER BY clause and resubmit.
SQL 4121
Cause. You attempted to perform a query with an aggregate function, a GROUP BY
clause, or a DISTINCT clause. A column in the ORDER BY clause,
name
, is not one of
the columns explicitly selected by the query.
Effect. The operation fails.
Recovery. Correct the ORDER BY clause and resubmit.
SQL 4122
Cause. You attempted to assign NULL to a NOT NULL column
name
.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4123
Cause. You attempted to cast NULL to a NOT NULL data type.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
4120 In a query with a GROUP BY, DISTINCT, or aggregate
function, each column in the ORDER BY clause must be one of
the columns explicitly SELECTed by the query. Column in
error:
name .
4121 In a query with a GROUP BY, DISTINCT, or aggregate
function, each column in the ORDER BY clause must be one of
the columns explicitly SELECTed by the query. Column in
error:
name . Table in scope: name .
4122 NULL cannot be assigned to NOT NULL column name .
4123 NULL cannot be cast to a NOT NULL data type.