Lesson 4: Inserting data in the remote database

This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating and configuring the consolidated database.

In this lesson, you insert data into the remote database to demonstrate that a schema change can proceed even if there are operations in the remote database that need to be uploaded.

 Insert data in the remote database

  1. Using the instance of Interactive SQL that is connected to the remote database, execute the following SQL statement to insert a row in the customer table. 

    INSERT INTO customer VALUES( 2, 'Sue Slow', '602-411-5467' );
COMMIT;

  2. Proceed to Lesson 5: Performing a schema change on the consolidated database.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1