The destination-template transfer statement allows you to transfer data and also allows you to feed a result set into a template and force the template to perform the following operations:

• Create a full-image copy (insert)

• Replace existing rows (replace or truncate)

• Create an incremental copy (insert)

• Modify column values (update or delete)

• Perform structural modifications (create or alter)

• Change database permissions (grant or revoke)

• Execute remote stored procedures (execute or use)

• Execute any other arbitrary SQL statement