Symptom
- 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
Read more...
Environment
- SAP BusinessObjects Data Services 4.0
- SAP Data Services 4.1
Product
SAP Data Services 4.0 ; SAP Data Services 4.1
Keywords
BODS, BODI, DS, DI, Edge, wrong, syntax, pushdown, push down, calculation, calculated, datetime , KBA , EIM-DS , Data Services , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.