The example includes the following elements:

• Wrapper procedure code sample

  new_dept(args...)
   
  if call_local='Y'
      call new_dept(Jones)
  if call_remote='Y'
      build call to new_dept
          for deferred queue
          with call_remote='N'
  

• Deferred transaction queue

  The following are entered under procname:

  update(oldargs newargs)
  insert(newargs)
  update(oldargs newargs)
  delete(oldargs)
  new_dept(Jones)
  

• Replication sites

  At both replication site A and replication site B, the procedure is called and the employees table is updated. The procedure call is similar to the following:

  new_dept(arg1)
  BEGIN
      lock table in EXCLUSIVE mode
      disable row-level replication
      update employees
      enable row-level replication
  END;