The dbmlsync utility initiates MobiLink synchronization for SQL Anywhere remote databases. Before starting dbmlsync, add order data and comments to your remote database.
Connect to the MobiLink client database in Interactive SQL:
Run the following command:
dbisql -c "eng=remote1;uid=DBA;pwd=sql" |
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') |
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') |
Commit your changes.
Execute the following in Interactive SQL:
COMMIT; |
At the command prompt, run the following command. Replace c:\MLobjxml with the location of your Java source files.
dbmlsync -c "eng=remote1;uid=DBA;pwd=sql" -e scn=on -o c:\MLobjxml\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. |
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 XML file.
For more information about dbmlsync, see SQL Anywhere clients.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |