The following is a sample parameter file that shows error handling and simple exceptions mapping for the source and target tables that are used in the CDR examples that begin. This example maps source and target columns, but no extra columns. For the following reasons, a COLMAP clause is not needed in the exceptions MAP statement in this example:

• The source and target exceptions columns are identical in name and definition.

• There are no other columns in the exceptions table.

  Note:

  This example intentionally leaves out other parameters that are required in a Replicat parameter file, such as process name and login credentials, as well as any optional parameters that may be required for a given database type. When using line breaks to split a parameter statement into multiple lines, use an ampersand (&) at the end of each line.

      -- REPERROR error handling: DEFAULT represents all error types. DISCARD
      -- writes operations that could not be processed to a discard file.
  REPERROR (DEFAULT, DISCARD)
      -- Specifies a discard file.
  DISCARDFILE /users/ogg/discards/discards.dsc, PURGE
      -- The regular MAP statement with the CDR parameters
  MAP fin.src, TARGET fin.tgt, &
  COMPARECOLS (ON UPDATE ALL, ON DELETE ALL), &
  RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (last_mod_time)), &
  RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, USEMAX (last_mod_time)), &
  RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, OVERWRITE)), &
  RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)), &
  RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD)), &
  );
      -- Starts the exceptions MAP statement by mapping the source table to the
      -- exceptions table.
  MAP fin.src, TARGET fin.exception, &
      -- directs Replicat only to map operations that caused the error specified
      -- in REPERROR.
  EXCEPTIONSONLY, &
      -- directs Replicat to convert all the exceptions to inserts into the
      -- exceptions table. This is why there cannot be a primary key constraint
      -- on the exceptions table.
  INSERTALLRECORDS 
  ;