Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 26, 2014 at 01:33 PM

    The SQL transform can only be used as a source in a dataflow. So by definition, only select operations are possible.

    Insert, delete and update operations are applied to targets only.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Dirk

        Thanks for your reply. From your reply i came to know Update or delete or insert wont work in SQL-Transformation. So deleting or inserting or updating i should Map_CDC operation rather than SQL queries.

      Thanks

      Vijay Mukunthan