SQL/MP Messages Manual
SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-12
SQL 7123
Cause. You specified a range of DATETIME or INTERVAL fields with a numeric
expression, a numeric column, or a character column. To specify a range of
DATETIME or INTERVAL fields, use DATETIME or INTERVAL values.
Effect. The statement does not compile.
Recovery. Remove the range of DATETIME or INTERVAL fields.
SQL 7140
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Change the operand so that it has the specified data type.
SQL 7141
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Change the operand so that it has the specified data type.
SQL 7150
Cause. You specified a column, pattern, or escape character in a LIKE predicate that
does not have a character data type. The LIKE predicate can be used only on
character data with type CHARACTER or VARCHAR.
Effect. The statement does not compile.
Recovery. Check the data types specified in the LIKE predicate and remove any
numeric operands.
7123 A range of DATETIME or INTERVAL fields can be specified
only with DATETIME or INTERVAL values.
7140 The operand for value-1 function must have a value-2
data type.
7141 The operand for the value-1 aggregate function must have
a NUMERIC or INTERVAL data type.
7150 An operand of the LIKE operator does not have a
CHARACTER data type.