Seven Stars

I want to iterate Numeric.Sequence(s1,1,1) every time i launch the job

I use Numeric.sequence("s1",1,1) as an autoincrement ID within one launch (so each row +1), but i want an auto-incremented ID for each time i launch the whole job (for the same job ID: 1 - the next time i launch the job ID: 2 a.s.o &&  ID is stored at Database). Any Solution for this???

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars

Re: I want to iterate Numeric.Sequence(s1,1,1) every time i launch the job

@meetmahajan,i suggest you read the Id and store in memory using tSetGlobalvar or tJava you can use globalmap.put and then in the next flow read the that globalmap value using (integer) type in Numeric.Sequence.

Manohar B
2 REPLIES
Twelve Stars

Re: I want to iterate Numeric.Sequence(s1,1,1) every time i launch the job

@meetmahajan,i suggest you read the Id and store in memory using tSetGlobalvar or tJava you can use globalmap.put and then in the next flow read the that globalmap value using (integer) type in Numeric.Sequence.

Manohar B
Twelve Stars

Re: I want to iterate Numeric.Sequence(s1,1,1) every time i launch the job

it will not work as requested - between Job executions, because memory released when Job finished

solution is in a question - store value in Database

in sequence

s1 - it is name, could be any like "ExecutionNumber"
1 - start value, could be any

2 - incremental step, could be any

 

so, if at the end of Job save Current value of sequence ExecutionNumber in Database (or csv file)
and on begin of Job check this value and use as start value for sequence, all would work

-----------