Symptom
A regular expression 'REGEXP' in 'delete' sql returns an error, whereas similar 'select' query works well.
(DBA)> delete from testa where cola REGEXP '.*efghi.*'
=> Error
Could not execute statement.
Update operation attempted on non-updatable remote query
SQLCODE=-728, ODBC 3 State="42000"
Line 1, column 1
delete from testa where cola REGEXP '.*efghi.*'
Read more...
Environment
SAP IQ16.1 SP04
Product
SAP IQ 16.1
Keywords
REGEXP , REGEXP_SUBSTR , , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.