How to pass column value as parameter

parameswar · Post by **parameswar** » Tue Jul 10, 2007 10:52 am

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.

DSguru2B · Post by **DSguru2B** » Tue Jul 10, 2007 11:17 am

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.

parameswar · Post by **parameswar** » Wed Jul 11, 2007 2:46 am

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.

Thanks Guru for your inputs. Job is running fine.

Regards,
Param