SSC-FDM-TD0032

CASESPECIFIC clause was removed from LIKE expression

Some parts in the output code are omitted for clarity reasons.

Description

This error appears when the LIKE expression is accompanied by the [NOT] CASESPECIFIC clause.

Example Code

Input Code:

IN -> Teradata_01.sql

SELECT * FROM MY_TABLE
WHERE Name Like 'Marco%' (NOT CASESPECIFIC);

Output Code

OUT -> Teradata_01.sql

SELECT
    * FROM
    MY_TABLE
WHERE Name ILIKE 'Marco%' /*** SSC-FDM-TD0032 - NOT CASESPECIFIC CLAUSE WAS REMOVED ***/;

Recommendations

• Case-Specific Behavior in TERADATA depends on TMODE system configuration.

• If you need more support, you can email us at [email protected]