DSXchange

I have got 2 values in 2 different tables which has to be passed as parameters to a set of jobs in job sequencer.how to do this. any of the jobs in the job sequencer should be able to access this values.

Load them into a file. Use cat filename.txt to read the contents of that file via Execute Command Stage and pass it to your sequence job. Just covered this over the weekend. Refer herefor details.

the 2 values will be from 2 different tables, then should I have 2 txt files.they are different columns, 1 is a date and other is a integer

You can have as many different files as you want. Just make sure you cat the correct file for the correct parameter value.

is the command activity stage same as execute command stage

Yes. The one thats present in the sequence job.

i created a execute command job and gave the full path name of the sequential file preceeded by the word type in the command box and executed it and it says file not found but the file is present.

when I gave cat and full path name that exec job says executed cat.

what command are you using?Are you specifying the parameters properly? Do check that.

i have created an execute command job and have given cat filename, now after that I have got a job activity in the job sequence that is calling this execute command job, but how do i associate the job parameter with the value coiming from the sequenctial file.

Did you read that post that i embedded in my very first reply ?

yed, do only i have something.
what should I give in the job properties of the sequence job.

yes so only i have something

You must have missed the second page. This is a direct copy paste from there:

Inside the jobactivity, where your specifying $CommandOutput, provide the following OR simply

its giving dss set param error