Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Storage Classifications
  24. Appendix A: Datetime and Numeric Formatting
  25. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Script Template

Script Template

When you run an archive or retirement job, the job uses a script template to create one script for each table the job extracts data from. The script template includes a scripting language that is supported by Teradata. The script template includes parameters that the job fills in with values at run time.
The script template, TPT_EXTRACT_SCRIPT_TEMPLATE, is packaged as an Enterprise Data Manager API. Optionally, you can copy the script template and customize the scripting language and the parameters. The name of the script template is configured in the Teradata source connection.
The job uses the script template to substitute values for the parameters and creates one script for each table. The job uses
<Job ID>_<Table Name>.bcp
as the naming file convention to create the script. The job saves the scripts in the
<Data Archive installation directory>/webapp/tmp
directory. The scripts are temporary files that Teradata Parallel Transporter uses to process data for individual tables.
The scripts include query requests. Teradata Parallel Transporter optimizes and rewrites the query requests and runs the scripts. Teradata Parallel Transporter creates one BCP file for each table. The BCP file includes the query results. After the Teradata Parallel Transporter creates the BCP files, the job deletes the scripts.

0 COMMENTS

We’d like to hear from you!