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

SQL Anywhere 12.0.0 (Français) » MobiLink - Getting Started » MobiLink Tutorials » Tutorial: Changing a schema using the script version clause

 

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;