Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Changing a schema using the script version clause

 

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.