The business rules governing customers are as follows:
Customer information can be modified at both the consolidated and remote databases.
Both the remote and consolidated databases contain a complete listing of customers.
Customer information can be inserted or updated at the consolidated database. The script corresponding to these operations is as follows:
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} |
Customer information can be inserted, updated, or deleted at the remote database. The scripts corresponding to these operations are as follows:
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} |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |