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-34
SQL 4133
Cause. The type of the trim source and trim character is not CHARACTER.
Effect. The operation fails.
Recovery. Make sure the type of the source and trim character is CHARACTER.
SQL 4134
Cause. You attempted to perform an operation that SQL/MX does not allow.
Effect. The operation fails.
Recovery. Try a UNION ALL operation and resubmit.
SQL 4135
Cause. You tried to SQL-compile an INSERT-SELECT statement that specified an
ORDER BY column that is not in the select list of the query.
Effect. The operation fails.
Recovery. Omit the ORDER BY clause or specify an ORDER BY column that is also
in the select list of the INSERT-SELECT query and resubmit.
SQL 4150
Cause. You performed an embedded DELETE or UPDATE and are now attempting to
join the result set of whatever that operation was with the result set of another
expression. You did not use the primary key of the second expression for your join. You
must use the primary key to prevent returning multiple rows being returned for a single
deleted or updated row.
Effect. SQL/MX is unable to compile the statement.
4133 Both trim character and source have to be CHARACTER
type.
4134 The operation (name) is not allowed. Try UNION ALL
instead.
4135 In an INSERT-SELECT, each column in the ORDER BY clause
must be one of the columns in the selected list of the query.
Column in error: B.
4150 Primary key of table expression name must be used for
join with embedded operation expression. Tables in scope:
name.