Description of the illustration repma008.eps

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;   
```