JR40285: IWAY Enterprise stage returns error message STATEMENT CONTAINS UNKNOWN SCALAR FUNCTION 'REPLACE' ON LINE 4 DETAILS: Iway Enterprise stage fails with message 'MESSAGE: IWAY_ENTERPRISE_3: STATEMENT CONTAINS UNKNOWN SCALAR FUNCTION 'REPLACE' ON LINE 4' RESOLUTION IWAY Enterprise stage supports only ANSI SQL syntax by default, which does not recognise REPLACE funtion. The solution is to mark the query as pass through to DB2. 1) Add the env APT_IWAY_GET_SCHEMA_WITH_EDA_PARAMS and set it to 1 2) Modify the job to add EDA Settings to Options and set it to ENGINE=1;