How to write the update script

dhp7021 Jul 26, 2012 2:16 AM

I need a update script to update A column in Table A to B column in Table B, below is the update script which can run in MS SQL SERVER

update a set a.COL_A = b.COL_B

from TABLE_A a, TABLE_B b

where a.ID = b.ID

How can I write the script in Teiid?

1. Re: How to write the update script

rareddy Jul 26, 2012 10:21 AM (in response to dhp7021)

Teiid supports standard ANSI SQL.
Actions
2. Re: How to write the update script

rareddy Jul 26, 2012 10:33 AM (in response to dhp7021)
BTW, if you are using Teiid Designer, after you define the view and its transformation, there are couple tabs to provide the insert/update/delete transformation that need to carry out for that view. These transformations are defined using INSTEAD OF triggers like

CREATE TRIGGER ON A INSTEAD OF UPDATE FOR EACH ROW BEGIN ATOMIC UPADTE A SET A.COL_A=... WHERE A.ID=... END

See https://docs.jboss.org/author/display/TEIID/Update+Procedures also note that since this block is defined as procedure Teiid provides PROCEDURE language
to define any constructs

Ramesh..
Actions
3. Re: How to write the update script

dhp7021 Jul 29, 2012 9:19 PM (in response to rareddy)

Thank you Ramesh, I find another way, I created a linked server in ms sqlserver, and the problem solved
Actions