Connect to your consolidated database in Interactive SQL if you are not already connected.

Run the following command:

dbisql -c "dsn=mldirect_db"

Use the ml_add_table_script stored procedure to add SQL-based table scripts for the upload_insert, download_cursor and download_delete_cursor events.

Run the following SQL script in Interactive SQL. The upload_insert script inserts the uploaded order_id, product_id, quantity, and order_status into the MobiLink consolidated database. The download_cursor script uses timestamp-based filtering to download updated rows to remote clients.

CALL ml_add_table_script( 'default', 'RemoteOrders', 
    'upload_insert',
    'INSERT INTO RemoteOrders( order_id, product_id, quantity, order_status)
     VALUES( ?, ?, ?, ? )' );
   
CALL ml_add_table_script( 'default', 'RemoteOrders',
    'download_cursor',
    'SELECT order_id, product_id, quantity, order_status
     FROM RemoteOrders WHERE last_modified >= ?');

CALL ml_add_table_script( 'default', 'RemoteOrders',
    'download_delete_cursor', '--{ml_ignore}');

COMMIT

Connect to your consolidated database in Interactive SQL if you are not already connected.

Run the following command:

dbisql -c "dsn=mldirect_db"

Register a Java or .NET method for the end_download event.

You use this method to free memory resources when the MobiLink server runs the end_download connection event.

For Java, run the following SQL script in Interactive SQL:

CALL ml_add_java_connection_script( 'default',
    'end_download',
    'MobiLinkOrders.EndDownload' );

For .NET, run the following SQL script in Interactive SQL:

CALL ml_add_dnet_connection_script( 'default',
    'end_download',
    'MobiLinkOrders.EndDownload' );

Interactive SQL registers the user-defined EndDownload method for the end_download event.

Register Java or .NET methods for the handle_UploadData and handle_DownloadData events.

For Java, run the following SQL script in Interactive SQL:

CALL ml_add_java_connection_script( 'default', 
    'handle_UploadData',
    'MobiLinkOrders.GetUpload' );
   
CALL ml_add_java_connection_script( 'default',
    'handle_DownloadData',
    'MobiLinkOrders.SetDownload' );

For .NET, run the following SQL script in Interactive SQL:

CALL ml_add_dnet_connection_script( 'default', 
    'handle_UploadData',
    'MobiLinkOrders.GetUpload' );
   
CALL ml_add_dnet_connection_script( 'default',
    'handle_DownloadData',
    'MobiLinkOrders.SetDownload' );

Interactive SQL registers the user-defined GetUpload and SetDownload methods for the handle_UploadData and handle_DownloadData events, respectively. You create these methods in an upcoming lesson.

Register download_cursor and download_delete_cursor events.

Run the following SQL script in Interactive SQL:

CALL ml_add_table_script( 'default', 'OrderComments',
    'download_cursor', '--{ml_ignore}');

CALL ml_add_table_script( 'default', 'OrderComments',
    'download_delete_cursor', '--{ml_ignore}');

The download_cursor and download_delete_cursor events must be registered for the OrderComments table when using scripts because the synchronization is bi-directional and not upload-only. See Required scripts.

Commit your changes.

Run the following SQL script in Interactive SQL:

COMMIT;