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

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

 

Lesson 4: Inserting data in the remote 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.

Prerequisites

This lesson assumes you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Changing a schema using the script version clause.

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

 Task
  • 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;

Results

The data is inserted into the remote database.