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 these operations:

• Create a full-image copy (insert)

• 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 other arbitrary SQL statements