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.
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.
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;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|