DSXchange

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

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.

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.

Or that.