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-15
SQL 4055
Cause. You specified select lists or tuples with incompatible data types.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4056
Cause. You specified a statement with an exposed table name that appears more than
once. For example:
SELECT * FROM tblx, tblx;
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4057
Cause. You specified correlation name1, which conflicts with a qualified identifier of
table name2. For example:
SELECT * FROM tblx, tblz, tblx;
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4059
Cause. You specified the first operand of function name with a type other than
numeric, which is required.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
4055 The select lists or tuples must have comparable data
types. type1 and type2 are not comparable.
4056 Exposed name name appears more than once.
4057 Correlation name name1 conflicts with qualified
identifier of table name2.
4059 The first operand of function name must be numeric.