This script creates a stored procedure update_ authors_pubs2 that updates the authors table in the pubs2 database. Create the same procedure at the primary and replicate sites.
-- Execute this script at the Tokyo and Sydney data servers -- Creates the stored procedure update_authors_pubs2 create procedure upd_authors_pubs2 (@au_id id, au_lname varchar(40), au_fname varchar(20), phone char(12), address varchar((12), city varchar(20), state char(2), country varchar(12), postalcode char(10) as update authors set au_lname = @varchar(40), au_fname = @varchar(20), phone = @char(12), address = @varchar((12), city = @varchar(20), state = @char(2), country = @varchar(12), postalcode = @char(10) where au_id = @au_id go /* end of script */
