Toad is flagging function REGEXP_LIKE as a syntax error "The XML was improperly formatted. Please escape it if necessary" (4310949)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Toad is flagging function REGEXP_LIKE as a syntax error "The XML was improperly formatted. Please escape it if necessary"
Description

Function REGEXP_LIKE was introduced in DB2 11.1. When using it in a sql statement, Toad is flagging it as an error:
Example:
SELECT NAME, SURNAME FROM TBO.PERSON
WHERE REGEXP_LIKE(SURNAME, 'Mor+?icone')
Toad flags with error "The XML was improperly formatted. Please escape it if necessary"
Resolution

WORKAROUND
The statement will execute. No, workaround is required
STATUS
Waiting for fix in a future release of Toad for DB2
Defect ID

QP-3271

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title