To set up your remote data (client-side)

1. Connect to the MobiLink client database in Interactive SQL:

   Run the following command:

   dbisql -c "eng=remote1;uid=DBA;pwd=sql"

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

   Execute the following command in Interactive SQL.

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

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

   Execute the following command in Interactive SQL.

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

4. Commit your changes.

   Execute the following in Interactive SQL:

   COMMIT;

To start the synchronization client (client-side)

• At the command prompt, run the following command (on a single line):

  dbmlsync -c "eng=remote1;uid=DBA;pwd=sql" -e scn=on -o rem1.txt -v+

  Below is a description of each option:

  Option	Description
  -c	Specifies the connection string.
  -e scn	Sets SendColumnNames to on. This is required by direct row handling if you want to reference columns by name.
  -o	Specifies the message log file rem1.txt.
  -v+	The -v option specifies what information is logged. Using -v+ sets maximum verbose logging.