The Execute Command stage just runs operating system commands. To "read" a file one would generally just "cat" it and then check $CommandOutput for the returned values.
-craig
"You can never have too many knives" -- Logan Nine Fingers
To read two columns from a files (just 1 record in it) into UVA stage variables,
currently i am using Command Activity stage twice on the same file . Once i
extracting columns 1 into one of the UVA variables and then extract columns 2 into another UVA variable.
Is there a better way to do it , like in just one go, rather than using Command Activity stage twice.
Thanks & Regards
Suhel Khan
Env Info:
DataStage Version : 8.5
DSEngine Platform : Windows Server 2008 R2
DWH Platform : Oracle 10g