Page 1 of 1

in datastage how to reset a sequence-number-generator

Posted: Mon Apr 27, 2009 12:28 am
by ppradeep_faq
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

Posted: Mon Apr 27, 2009 2:29 am
by ray.wurlod
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).

Posted: Mon Apr 27, 2009 6:27 am
by chulett
"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.