How to use Global Variables for all Data flows in a Process flow


Technique

Product: DataMigrator
Release: 8205
Primary OS: Windows
Solution Date:

Problem

How to use Global Variables for all data flows in a Process flow.

Solution

Here are the steps to use Global Variables for all data flows in a Process flow.



    
	
  1. Create a procedure at the start of the Process flow
    2. 
	
  2. This new procedure should:
	
      
		
    1. Run a specific request that returns the desired value and places it into a HOLD file.
      2. 
		
    2. Run a small set of Dialogue Manager commands to perform a -READFILE of the HOLD to place the value into an &VARIABLE.
      3. 
	
    
	
    3. 
	
  3. Copy that into an &&VARIABLE 
    4. 
	
  4. Mark the new procedure object as  Run as a Stored Procedure for the Process flow to ensure it runs in the same agent so that subsequent flows can reference the &&VARIABLE value.
    5. 




For additional information refer to the Advanced Data Migrator Tips and Techniques section under Using Variables in Data Flows which contains examples as well for processing variables in a Data Flow.