DSXchange

JoshGeorge wrote:Fair enough ! For those whose find the above routine is suitable, use it, if someone believe it needs improvement, please create and use.

ray.wurlod wrote: If I believe an SDK routine is suitable for my purposes, I use it; if I believe it needs improvement, I create and use ...

Hi,
I have one solution, Correct me if I am wrong.

In that particular Job Transfarmer go for the propertis and select the befour subroutine and select the exicute TCL and give the vlaue as UPDATE SDKSequences USING DICT VOC SET F1 = '1' WHERE @ID = '1';

if we use this statement, every time when the job starts the seq. no also starts from 1

Sure... but if you always want to start from 1 use the @OUTROWNUM system variable instead.