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

Advanced Workflow Guide

Advanced Workflow Guide

Creating User Variables in the Control File

Creating User Variables in the Control File

When you configure MultiLoad or TPump external loader attributes, you can create user variables. User variables are custom-defined substitution variables that you use in the control file. User variables capture session specific information that may not be available in the connection object attributes. User variables are often used for pre- or post-load processing.
You define the user variable name and substitution value in the connection object. In the control file, you add the substitution variable prefix and the user variable name to the corresponding command. When you run the session, the Integration Service replaces the substitution variable prefix and the user variable name in the control file with the substitution value. If you change the substitution value after you edit the control file, the control file uses the new value.
Use the following rules and guidelines when you create user variables:
  • When you create the user variable, use the following syntax:
    <User_Variable_Name>=<Substitution_Value>
  • If you include spaces in the user variable name or the substitution value, the session may fail.
  • When you add the user variable to the control file, use the following syntax:
    :CF.<User_Variable_Name>


Updated June 25, 2020