How to filter replicat to exclude certain sets of @before and @after value in pairs

Nov 9, 2023 11:52PM

GGSCI (ip-10-85-223-47.us-west-2.compute.internal as oggown@EFIWCQBE) 7> VERSIONS

Operating System:

Linux

Version #1 SMP Tue Sep 26 09:59:02 UTC 2023, Release 4.14.326-245.539.amzn2.x86_64

Node: ip-10-85-223-47.us-west-2.compute.internal

Machine: Linux

Database:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

--

Question:

Looking at FILING.FILING_STATE column, exclude these transitions of value @before to @after

0 --> 1

1 --> 21

21 --> 12

12 --> 9

0 --> 20

20 --> 1

1 --> 12

1 --> 9

Extract:

TABLE ET.FILING, GETBEFORECOLS (ON UPDATE ALL) ;

Pump:

TABLE ET.FILING ;

Replicat

MAP ET.FILING, TARGET ET.FILING, &

FILTER (ON INSERT, @STREXT (SITE_ID, 1,3) <> '114'), &

FILTER (IGNORE UPDATE, @BEFORE(FILING_STATE)=0 AND @VALONEOF (FILING_STATE, 1,20) ) , &

GoldenGate, Streams and Distributed Database (MOSC)