file as a stage variable

[kaps]

How can I pass a valule to a DataStage job and use it in transformer for other purpose. Say I need to do a pre processing to get a date and pass that date to a job to compare with a field coming out of my input file.

I read somewhere in this forum that we can use a file as a stage variable when it has a value like this. so I stored that value in a file and substitute "cat /path/filename" as initial value of a stage variable I am just getting the whole string as a value. I am not getting the content of the file.

Thanks

[ray.wurlod]

You can only initialize the stage variable successfully by creating a routine that reads the file, and invoking that routine.

[kcbland]

Just mimic the before subroutine called ExecSH or ExecDOS using a Function. Now, that function takes your argument and executes it, returning the screen output as the answer.