download_cursor   The following download_cursor script downloads all customers for whom information has changed since the last time the user downloaded information.

SELECT cust_id, cust_name FROM ULCustomer WHERE last_modified >= {ml s.last_table_download}

upload_insert   The upload_insert script for CustDB is as follows:

INSERT INTO ULCustomer( cust_id, cust_name ) VALUES( {ml r.cust_id, r.cust_name } )

upload_update   The upload_update script for CustDB is as follows:

UPDATE ULCustomer SET cust_name = {ml r.cust_name} WHERE cust_id = {ml r.cust_id}

Conflict detection is not performed on this table.

upload_delete   The upload_delete script for CustDB is as follows:

DELETE FROM ULCustomer WHERE cust_id = {ml r.cust_id}