in datastage how to reset a sequence-number-generator

ppradeep_faq · Post by **ppradeep_faq** » Mon Apr 27, 2009 12:28 am

in datastage iam using a transformer stage in that iam using sequence-number-generator by KeyMgtGetNextValue() ,..this will give1,2,..10 No New sequence-number, and in job suppose iam getting error i need to compile the job again ,in then sequence-number-generator starts from 11to 20 new sequence-number-,,,,, but iam need to reset sequence-number-generator from 1,2,...10 like this ,how to do this ...plz can any one tell me plz,, this is my mail ID ppradeepoct23@gmail.com plz send to my mail ID

ray.wurlod · Post by **ray.wurlod** » Mon Apr 27, 2009 2:29 am

Welcome aboard.

Please use proper English on DSXchange; the word you wanted is "please", not "plz" (which isn't a word at all in English).

You can find your answer via Search. A good start point might be an exact search on Updaing SDKSequence (sic).

chulett · Post by **chulett** » Mon Apr 27, 2009 6:27 am

"in job suppose i am getting error i need to compile the job again"

No, no you don't. You Reset aborted jobs, not recompile them.