CASESPECIFIC clause was removed from LIKE expression
Last updated 7 months ago
Some parts in the output code are omitted for clarity reasons.
This error appears when the LIKE expression is accompanied by the [NOT] CASESPECIFIC clause.
LIKE
[NOT] CASESPECIFIC
SELECT * FROM MY_TABLE WHERE Name Like 'Marco%' (NOT CASESPECIFIC);
SELECT * FROM MY_TABLE WHERE Name LIKE 'Marco%' /*** SSC-FDM-TD0032 - NOT CASESPECIFIC CLAUSE WAS REMOVED ***/;
Case-Specific Behavior in TERADATA depends on TMODE system configuration.
If you need more support, you can email us at