Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Insert,Delete and Update wont support in SQL-Transform in BODS4.1

Dear Experts

In the SQL-Transform when i use select statement with multiple nested conditions it works fine. But when i use delete statement its gives syntax error. Does it mean that SQL-Transform wont support any Insert, Delete or Update Statement? How to achieve these statements in SQL-Transform then?.

  When i use the same delete statement in oracle it works fine and gives correct result.

Regards

Vijay Mukunthan

replied

Note that the Data Integrator component of DS is not a SQL-tool but an ETL-tool, slightky different way of thinking required . We achieve your results with a dataflow as:

Specify a where-clause in the Query transform to filter out the records you want to delete. Then change  the row type from Normal to Delete in the Map Operation transform.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question