max value of table column value as vriable in the sequencer

srinivas Guduru · Post by **srinivas Guduru** » Mon May 16, 2011 9:52 pm

Hi
I need to use a Data base table, Row_ID is the primary key, I need to get max value of ROW_ID and max value of ROW_ID value should available throughout (every where) the sequencer.
Like a parameter value, max value of ROW_ID should available any where in the sequencer

Can any one suggest me please

Thanks
Srini

chulett · Post by **chulett** » Mon May 16, 2011 10:02 pm

Then you'll need to determine it outside the Sequence job and pass it into the Sequence as a job parameter. Another Sequence could be used to accomplish that.

ray.wurlod · Post by **ray.wurlod** » Mon May 16, 2011 11:13 pm

Make the first (or an early) activity in the sequence a Job activity that fetches the maximum value and loads it into its own user status area. A server job is always recommended for processing just one row. The job activity's $UserStatus activity variable is available anywhere downstream of the activity.

chulett · Post by **chulett** » Tue May 17, 2011 6:28 am

Or that.