SQL Remote User's Guide
Tutorials for Adaptive Server Anywhere Users
Start replicating data
First, enter some data into the consolidated database.
To enter data at the consolidated database
Connect to the consolidated database hq from the Interactive SQL utility with a user ID of DBA and a password of SQL.
Insert two rows into the SalesRep table and commit the insertion by executing the following statement:
INSERT INTO SalesRep (rep_key, name) VALUES ('rep1', 'Field User') ; INSERT INTO SalesRep (rep_key, name) VALUES ('rep2', 'Another User') ; COMMIT ;
Insert two rows into the Customer table and commit the insertion by executing the following statement:
INSERT INTO Customer (cust_key, name, rep_key) VALUES ('cust1', 'Ocean Sports', 'rep1' ) ; INSERT INTO Customer (cust_key, name, rep_key) VALUES ('cust2', 'Sports Plus', 'rep2' ) ; COMMIT ;
Confirm that the data has been entered by executing the following statements:
SELECT * FROM SalesRep; SELECT * FROM Customer;
The next step is to send the relevant rows to the remote database.