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;

5. Create a blank text file called orderResponses.txt in the same directory as your consolidated database.

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.

To return comments using direct row handling downloads (server-side and client-side)

1. Close any SQL Anywhere MobiLink Client windows

2. Insert return comments. This action takes place on the server side.

   Add the following text to orderResponses.txt. You must separate entries using the tab character. At the end of the line, press Enter.

   1 1 Promotional material shipped

3. Run synchronization using the dbmlsync client utility.

   This action takes place on the client-side.

   Run the following command:

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

   The MobiLink client utility appears.

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