update Parameter set for every run

[kpsita]

Hi,

I have a parameter set with one value

Parameterset = Maxdate

when I start my sequence I need to update this Maxdate value with the maximum update date value from a table.How can I do this. Is it possible to do it using a routine or is there any other alternate to get the parameter value changed for daily run.I will not be able to change it manually because I have to do the same for more than 50 tables.Any help is appreciated.

Thanks,

[chulett]

It's a normal flat file so you have a number of options on how to change it, especially if it is the only record in the file. You could use a job, do something in a routine, even a shell script.

[rohithmuthyala]

Hi,

You can maintain a separate flat file, which will calculate the maximum value and stores in it before running your job, your sequencer can read the corresponding value from the above file created.