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

SQL Anywhere 12.0.0 » 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;