Diagnostics
Symptom
(FOC14037) SELECT STATEMENT THAT CANNOT USE APT CONTAINS DB_EXPR(FOC14037) SELECT STATEMENT THAT CANNOT USE APT CONTAINS DB_EXPR
Problem
The user receives the error message above when a DataMigrator Flow contains a Target Transformation using DB_EXPR.
Solution
To address this issue, make the transformation dynamic by including columns from the source tables. For example:
DB_EXPR(CAST(RIGHT(SPACE(fld_len) + CAST(COALESCE("T2.QUANTITY",0) AS VARCHAR(fld_len)) , fld_len) AS CHAR(fld_len))) AS fld_nm