1 Reply Latest reply on Jul 31, 2013 12:45 AM by marie.couch

    syntax in 11.2 OGG version

    user13534672

      Hi ,

       

      Our current setup is OGG 11.1.1.0.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, &
      TRACE ALL),&
      FILTER (service.mtservice  = 0, ON UPDATE, RAISEERROR 21000);

      MAP GIAADMIN.HRZ_MT_SERVICE, TARGET GIAADMIN.HRZ_MT_SERVICE_EI, EXCEPTIONSONLY, &
      INSERTALLRECORDS, &
      COLMAP (USEDEFAULTS , errtype = "UPDATE FILTER FAILED.", &
      DML_DATE = @DATENOW(), &
      optype = @GETENV ("lasterr", "optype"), &
      dberr = @GETENV ("lasterr", "dberrnum"), &
      dberrmsg = @GETENV ("lasterr", "dberrmsg"));

       

      Thanks

        • 1. Re: syntax in 11.2 OGG version
          marie.couch

          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.

           

          Best regards,

          Marie