Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data
  26. POWERCENTERHELP

Advanced Workflow Guide

Advanced Workflow Guide

Step 4. Override the Control File (Optional)

Step 4. Override the Control File (Optional)

By default, the Integration Service generates a FastExport control file based on session and connection properties when you run a session with FastExport. The Integration Service saves the control file it generates in the temporary file directory and overwrites it the next time you run the session.
You can override the control file that the Integration Service generates. When you override the control file, the Workflow Designer saves the control file to the repository. The Integration Service uses the saved control file when you run the session.
Each FastExport statement must meet the following criteria:
  • Begin on a new line.
  • Start with a period (.).
  • End with a semicolon (;).
The following table describes the control file statements you can use with PowerCenter:
Control File Statement
Description
.LOGTABLE utillog;
The restart logtable name.
LOGON tdpz/user,pswd;
The database login string, including the database, user name, and password.
BEGIN EXPORT
The first export command.
.SESSIONS 20;
The number of Teradata sessions.
.EXPORT OUTFILE ddname2;
The destination file for the exported data.
SELECT EmpNo, Hours FROM charges
The SQL statements to select data.
WHERE Proj_ID = 20
-
ORDER BY EmpNo ;
-
.END EXPORT ;
Indicates the end of an export task and initiates the export process.
LOGOFF ;
Disconnect from the database.
To override the control file:
  1. Create a control file in a text editor.
  2. Copy the control file text to the clipboard.
  3. Paste the control file text into the Control File Override field.
The Workflow Manager does not validate the control file syntax. Teradata verifies the control file syntax when you run a session. If the control file is invalid, the session fails.
You can change the control file to read-only to use the control file for each session. The Integration Service does not overwrite the read-only file.


Updated July 04, 2018