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