Our current setup is OGG 22.214.171.124.0 . below is the replication file content . Very soon we are going to 11.2 OGG version Can we use below replication file content in 11.2 OGG version . because these file contents are tested and verified . we dont want to change these codings in 11.2 verson OGG . Will it be working in 11.2 OGG version ? Please help.
MAP GIAADMIN.HRZ_MT_SERVICE, TARGET GIAADMIN.HRZ_MT_SERVICE, &
REPERROR (21000, EXCEPTION), &
SQLEXEC (ID service, ON UPDATE, &
QUERY "select count(*) mtservice from GIAADMIN.HRZ_MT_SERVICE where SERVICE_ID = :p24 and &
UPDT_DT > :p25", &
PARAMS ( p24 = SERVICE_ID , p25 = UPDT_DT ), BEFOREFILTER, ERROR REPORT, &
FILTER (service.mtservice = 0, ON UPDATE, RAISEERROR 21000);
MAP GIAADMIN.HRZ_MT_SERVICE, TARGET GIAADMIN.HRZ_MT_SERVICE_EI, EXCEPTIONSONLY, &
COLMAP (USEDEFAULTS , errtype = "UPDATE FILTER FAILED.", &
DML_DATE = @DATENOW(), &
optype = @GETENV ("lasterr", "optype"), &
dberr = @GETENV ("lasterr", "dberrnum"), &
dberrmsg = @GETENV ("lasterr", "dberrmsg"));
None of the above parameters have been deprecated, so the behavior would be expected to be the same on the new release. But you can't just look at parameters and know if they will work exactly the same on the new software release - best practices would dictate that you test with the new version to verify that functionality is preserved.