Lesson 7: Insert data in the remote database

In this lesson, you insert some more data into the remote and consolidated databases using the new schema.

 To insert data in the remote database

  1. Using Interactive SQL, execute the following SQL against the remote database:

    INSERT INTO customer VALUES( 3, 'Mo Hamid', '613-411-9999', '613-502-1212' );
COMMIT;

  2. Using Interactive SQL, execute the following SQL against the consolidated database:

    INSERT INTO customer VALUES( 101, 'Theo Tug', '212-911-7677', '212-311-3900' );
COMMIT;
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0