1851887 - DB2 date arithmetic push-down in Data Services incorrect

WHERE clause in Query transfom containing condition similar to: "SOMETABLE"."SOMEDATEFIELD" > sysdate() -365
Gets pushed down as seen in View optimized SQL as: "SOMETABLE"."SOMEDATEFIELD" > (current timestamp - 365))
When the correct SQL for push-down to DB2 should look like: "SOMETABLE"."SOMEDATEFIELD" > (current timestamp – 365 days)
Error when running ETL job:
SQL submitted to database <SAMPLE> resulted in error <[IBM][CLI Driver][DB2/NT64] SQL0182N An expression with a datetime value or a labeled duration is not valid. SQLSTATE=42816

SAP Data Services 4.0 ; SAP Data Services 4.1

BODS, BODI, DS, DI, Edge, wrong, syntax, pushdown, push down, calculation, calculated, datetime , KBA , EIM-DS , Data Services , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Visit SAP Support Portal's SAP Notes and KBA Search.