Thats not undocumented error. Insert and Update have their own purpose.
Your UPDATE statement in INSERT tag is never executed since you have good db.
Make any one first column value as NULL and check the results. You would get error message.
For more details refer http://www.kpipartners.com/blog/bid/83128/Writeback-in-OBIEE
mark if Helps.
Thanks for the reply.
If i remove Update statement in INSERT tag, i get following error.
[nQSError: 27024] The EXECUTE PHYSICAL statement must specify a physical SQL statement to execute.
With the help of some blogs i came to know if we supply same Update statement in INSERT tag as well, we can get rid of this error. I did it and now I am not getting any error. This is really surprising but this is what i want to understand why do we need to do this?
I did not understand following line in your reply. would you please elaborate?
Make any one first column value as NULL and check the results
Change value to NULL in tables first column as below,
a b c
1 2 3
NULL 4 2
3 23 3