on 05-24-2016 4:51 PM
Hello SAP Community,
we successfully replicated a simple view (a view which presents the content of a table and a view which displays a subset of a table).
However we have not been able to replicate a more complex view. Even a view which displays only an additional column (copy of another column with a synonym) was not possible.
Does somebody know the limitations for views and if there exist some work-arounds? E.g. materialized view?
Thanks in advance
Thorsten
Hi Thorsten,
Replication of views should not be a problem, you can easily replicate database view which involves more than 1 tables.
Only thing which u need to remember is that first all the underlying tables need to be replicated before replicating a view.
Regards
BJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Again.
I just saw that I did not mention the system configuration. What we want to do is:
1. Replicate from DB2 10.5 to DB2 10.5
2. Replicate from DB2 10.5 to ODQ / BW
At the moment I am trying to to replicate a view from DB2 to DB2.
SLT Relase DMIS 2011_1_731 SP Level 10.
So I tried the solution you described:
1. Create Table on DB2 source
2. Replicated the source successfully
3. Created a simple view on DB2 source (select one column from src table)
4. Added the view in Transaction LTRS
-> view did not appear in destination system (DB2 10.5)
Additionally I tried to replicate as described here:
1. Create table and view in source system
2. added view in LTRS (removed 1 column) Table: ID, DESC, View: DESC
3. Start replicating by adding the table name in transaction LTRC.
--> Result was that a table was created in the destination with only the ID column (as expected)
Unfortunately no data appears in the destination.
The status in transaction LTRC is Replication(initial load) - nothing happens after that.
What I noticed as strange when adding the view in LTRS is that the table structure is recognized correctly on the left side.
But the modified table structure is empty.
Then I tried to remove the column desc which resulted on the right side that DESC is marked as "remove".
Then clicking on the button "View Modivied Table Structure" resulst in an empty structure (as bevor - nothing changed here)
I would expect the changed table structure to contain only ID - not nothing.
hello,
Can you share some screen shot for the error msg
Amar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.