Connect to the MobiLink client database from Interactive SQL if you are not already connected.

Run the following command:

dbisql -c "SERVER=remote1;UID=DBA;PWD=sql"

Add an order to the RemoteOrders table in the client database.

Execute the following SQL statement in Interactive SQL:

INSERT INTO RemoteOrders (order_id, product_id, quantity, order_status)
 VALUES (1,12312,10,'new');

Add a comment to the OrderComments table in the client database.

Execute the following SQL statement in Interactive SQL:

INSERT INTO OrderComments (comment_id, order_id, order_comment)
 VALUES (1,1,'send promotional material with the order');

Commit your changes.

Execute the following SQL statement in Interactive SQL:

COMMIT;

Run the following command at a command prompt:

dbmlsync -c "SERVER=remote1;UID=DBA;PWD=sql" -o rem1.txt -v+

The following table contains a description for each dbmlsync option used:

Once you have started the MobiLink synchronization client, an output screen appears indicating that the synchronization succeeded. SQL-based synchronization transferred rows in the client RemoteOrders table to the RemoteOrders table in the consolidated database.

Java processing inserted your comment in the order_central.xlsx worksheet. The information stored in the order_central.xlsx worksheet is downloaded to the client.

In Interactive SQL, select from the OrderComments table to verify that the row was downloaded.

Execute the following SQL statement in Interactive SQL:

SELECT * FROM OrderComments;