-
1. Re: Error in creating the Updatable View Model
jdoyle Jul 26, 2010 9:27 AM (in response to rakeshsagar)Rakesh,
You will need to write the SQL for each operation (update/insert/delete) that maps the values coming into the virutal view table to the physical tables. In the simplest example, if your virutal view table has columns A and B coming from two different physical models, you need to create the SQL that updates/inserts/deletes those values in correct physical table. Teiid and Teiid Designer can't figure out what the logic required to perform these operations is, it can be complex, so you have to provide it.
~john
-
2. Re: Error in creating the Updatable View Model
rareddy Jul 26, 2010 10:53 AM (in response to rakeshsagar)To add to John's comment..
Also these updates can be performed transactional context. If your underlying sources are XA capable and you created the data sources using the XA data source, these updates are performed using a Transaction Manager. If you used single source under view then you do not need XA, however if used more than one source to define the transformation XA transactions can be used.
Ramesh..
-
3. Re: Error in creating the Updatable View Model
rakeshsagar Jul 28, 2010 5:42 AM (in response to jdoyle)Hi,
Can you please tell me how do we map/get the values coming into the virtual view table.
For example I have a view table which contains Columns A and B.
Column A is from Basetable1 and column B is from Basetable2
I need to insert the row into the Base table1 with column A's value and insert the row into the Base table2 with column B's value.
For this I need to write queries like
insert into BaseTable1 values(ColumnA's Value, ....);
insert into BaseTable2 values(ColumnB's Value, ....);
Can you tell me how do I get the values of ColumnA and ColumnB from the insert query.
Thanks
Rakesh