GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sintax error using FILTER AND @before

Arturo GutierrezFeb 9 2017 — edited Feb 10 2017

Hello,

After a lot of trys, I've a syntax error that I can't fix:

This is my replication file:

Map scott.CLTPEFIS, Target db2inst1.DPERELAC, &

KEYCOLS(ID_DPERSONA_REL), &

SQLEXEC (ID LOOKUP_SEQ16, &

QUERY "select id_dpersona from db2inst1.dpersona where numpers = ?", params (p1 = PARTI_COD_PARTI_PK)), &

SQLEXEC (ID LOOKUP_SEQ17, &

QUERY "select id_dpersona from db2inst1.dpersona where numedocu = ?", params (p1 = PEFIS_NUM_NIF_NUMT)), &

COLMAP( &

ID_DPERSONA_FK= @GETVAL (LOOKUP_SEQ16.id_dpersona), &

TIPORELA='TUTOR', &

USUALTA = PEFIS_NOM_UCREACIO, &

FECHALTA = PEFIS_FEC_FMODIFIC, &

ID_DPERSONA_REL= @GETVAL (LOOKUP_SEQ17.id_dpersona)),

FILTER ( PEFIS_NUM_NIF_NUMT <> @BEFORE(PEFIS_NUM_NIF_NUMT) and @BEFORE(IS_NUM_NIF_NUMT) <> @NULL and PEFIS_NUM_NIF_NUMT <> @NULL );

And the error is:

2017-02-10 00:46:30 ERROR OGG-00207 Invalid FILTER specification (could not find open parenthesis).

Do you know how fix this error?

Many Thanks

Arturo

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2017

Added on Feb 9 2017

#goldengate

3 comments

528 views