SAP Knowledge Base Article - Preview

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

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.