xeqister
MIS
- Jul 17, 2012
- 1
Dear all,
I would like to check whether the following row filter is valid for the APPLY program in DB2 replication.
(Col1, Col2) IN (SELECT ColA, ColB, ColC FROM SCHEMA.TableA WHERE ColD IN ('Value1', 'Value2') OR ColE IN ('Value1', 'Value2'))
I noticed that when I add the above for row filter in one of the replication table, replication will not work although APPLY program can be started up. And the above is a valid SQL where I have tested it on the source table. Does anyone have any idea how should I put the above condition as the replication criteria.
p.s: I am using DB2 Replication Center to setup replication.
Thanks in advance !!
I would like to check whether the following row filter is valid for the APPLY program in DB2 replication.
(Col1, Col2) IN (SELECT ColA, ColB, ColC FROM SCHEMA.TableA WHERE ColD IN ('Value1', 'Value2') OR ColE IN ('Value1', 'Value2'))
I noticed that when I add the above for row filter in one of the replication table, replication will not work although APPLY program can be started up. And the above is a valid SQL where I have tested it on the source table. Does anyone have any idea how should I put the above condition as the replication criteria.
p.s: I am using DB2 Replication Center to setup replication.
Thanks in advance !!