title: Is there a way to use User Activity Variables to store SQL in Datastage
body: <p>I am considering using RCP to run a generic datastage job, but the initial SQL changes each time it's called.  Is there a process in which I can use a User Activity Variable to inject SQL from a text file or something so I can use the same datastage? </p>
  
  <p>I know this Routine can read a file to look up parameters:</p>
  
  <pre><code>Routine = ‘ReadFile’
  vFileName = Arg1
  vArray = ”
  vCounter = 0
  OPENSEQ vFileName to vFileHandle
  Else Call DSLogFatal(“Error opening file list: “:vFileName,Routine)
  Loop
  While READSEQ vLine FROM vFileHandle
  vCounter = vCounter + 1
  vArray = Fields(vLine,’,’,1)
  vArray = Fields(vLine,’,’,2)
  vArray = Fields(vLine,’,’,3)
  Repeat
  CLOSESEQ vFileHandle
  Ans = vArray
  Return Ans
  </code></pre>
  
  <p>But does that mean I just store the SQL in one Single line, even if it's long? 
  Thanks.</p>