SQL$HELP72.HLB  —  Errors  SQL_ERRORS, MSP_LIKE_XLATE
  Translation of LIKE pattern string not supported in a compound
  statement

  Explanation:  A search condition within a compound statement
  references LIKE which must be translated to a BLR$K_MATCHES.
  The pattern string must be translated from the LIKE special
  characters to the MATCHES characters.  This cannot be done by
  the database system involved.

  User Action:  For Oracle Rdb systems, use the UPPER statement to
  convert characters to upper case and perform the LIKE statement
  on the result.  For non-Oracle Rdb systems, this string must be
  a compiletime literal.
Close Help