GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Goldengate Syntax for NULL check on user FILTER (ON UPDATE Question

edited Sep 20, 2013 3:59AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
 Can anyone provide assistance on syntax associate with filter records on DML update for where a field on the record is null
I know you can use @NULL with where feature but not sure how to combine that with FILTER and ON UPDATE

Following does not work

table rcaadmin.rca_file_tj, filter (ON UPDATE, c_card_serial_number = @NULL);


I am looking to replicate updates only where c_card_serial_number is null.

Thanks
Terry

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center