Master Mainframe Technologies - COBOL, JCL, DB2, VSAM, CICS & More
ABEND Codes SQLCODEs File Status Interview Prep Contact
← Back to SQLCODE Reference
Error

SQLCODE -130

Invalid use of escape character

Explanation

The escape character in LIKE predicate is invalid.

Solution

Use a single character for ESCAPE that does not appear in the pattern.

Example

WHERE NAME LIKE "%AB%" ESCAPE "%" -- % cannot be both wildcard and escape