Hi,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 ...
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