Hi,
I have a job which is creating a file with 2 columns . File contains 1 record only. Data in the file is 2007-04-12,2006.
I need to pass these value to FIVE different jobs as parameter.
How should I design the job to get this requirement.
Thanks in advance,
Param.
How to pass column value as parameter
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Design it using a sequence job. Have an execute command stage spit out the value using "cat". Then just perform a Field() function to get the first column and similarly the second column. Be sure to use CONVERT() for the second column to get rid of the field marker "@FM".
Perform the Field operation on Execute_command_stage.$Command_Output.
Perform the Field operation on Execute_command_stage.$Command_Output.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Thanks Guru for your inputs. Job is running fine.DSguru2B wrote:Design it using a sequence job. Have an execute command stage spit out the value using "cat". Then just perform a Field() function to get the first column and similarly the second column. Be sure to use CONVERT() for the second column to get rid of the field marker "@FM".
Perform the Field operation on Execute_command_stage.$Command_Output.
Regards,
Param