Insert,Delete and Update wont support in SQL-Transform in BODS4.1
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.
Dirk Venken 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.