I have a script written and i need to run the script in my datastge job and also use the output of the script in the same job for further transformation.
how do i do it?
Run script in DS job n get the script o/p in same DS job
Moderators: chulett, rschirm, roy
Use the before job subroutine "Execsh" to fire your script. Redirect your output to a file and then read that file in your datastage job. Make sure you adhere to the strict rules of meta data for the sequential file to read your output file without any fuss.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Another way to implement this is use the Execute stage in the Job sequence to execute yourscript.
Now capture the return value (.$ReturnValue ) or the command output value (.$CommandOutput) in the successive jobs.
Now capture the return value (.$ReturnValue ) or the command output value (.$CommandOutput) in the successive jobs.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.