Question Re: Update View and Proxy in Technology Q&A

Update View and Proxy

Former Member — Wed, 08 Mar 2017 05:00:37 GMT

Hi, we have created a proxy table 'orders' in our main database. We created a view 'v_orders' in our branch database for reading the data. This works fine. We can also do Updates on 'orders' from main and branch. But doing an update on 'v_orders' only works in the main database.

So how to update view which is pointing on a proxy table from the branch database?

Re: Update View and Proxy

VolkerBarth — Wed, 08 Mar 2017 07:01:04 GMT

Hm, I still do not understand how many database objects you refer to. For example, when saying "created a proxy table 'orders' in our main database" - what exactly does that mean? Is the table "orders" located in the main database or is it declared there as proxy table and the real table resides in another database?

It would be helpful if you could list the according (simplified) CREATE [EXISTING] TABLE / CREATE TABLE / CREATE VIEW commands (without column details) and in which database you have executed them..., and then tell which update statement work and which don't - again with telling in what database those are run.

Re: Update View and Proxy

Breck_Carter — Wed, 08 Mar 2017 07:28:44 GMT

If the view is a straightforward subset of columns, you can also define a subset in the CREATE EXISTING TABLE statement: "You may choose to include only a subset of the actual remote column list in your CREATE EXISTING statement."