SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

MXCI Messages (15000 through 15999)
HP NonStop SQL/MX Messages Manual—523730-004
14-71
Effect. The operation fails.
Recovery. Check that the operands belong to data type classes that can be operated
upon in a binary arithmetic expression.
SQL 15538
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 operation fails.
Recovery. Check the data types specified in the LIKE predicate and remove any
numeric operands.
SQL 15539
Cause. The SQL parser required a literal string at or near the position pointed to by
the marker.
Effect. The operation fails.
Recovery. Specify a literal string and recompile.
SQL 15540
Cause. You specified an invalid date and time to compute the timestamp.
Effect. The operation fails.
Recovery. Correct the syntax or values and resubmit.
SQL 15541
Cause. You specified an AS DATE or AS TIME format on an incompatible item type.
AS DATE or AS TIME can be specified only on an item having a LARGEINT data type.
Effect. The operation fails.
15538 An operand of the LIKE operator does not have a
CHARACTER type.
15539 A literal string is required here.
15540 An invalid date and time was entered. The valid format
is MM/DD/YY [Hr:Mi:Se:Ms:Us].
15541 AS DATE or AS TIME format specified on an incompatible
item type.