How to Reset Routine(KeyMgtGetNextValue)?

A_SUSHMA · Post by **A_SUSHMA** » Mon Mar 03, 2014 11:10 pm

Hi All,

How to reset the value to zero for "KeyMgtGetNextValue" before my process runs each time?

anbu · Post by **anbu** » Mon Mar 03, 2014 11:30 pm

Search for "UPDATE SDKSequences"

chulett · Post by **chulett** » Tue Mar 04, 2014 12:17 am

One such example here. However, if your sequence always starts at zero each run then there's really no need to be using a sequence. Why not simply increment a counter?

A_SUSHMA · Post by **A_SUSHMA** » Tue Mar 04, 2014 12:28 am

Hi Chulett,

I need to increment the audit table each time the condition is not satisfied.The audit table is used through out the process.I mean around 10 jobs.In each transfermor I need to incremnt the audit table

chulett · Post by **chulett** » Tue Mar 04, 2014 12:30 am

So a global sequence... that's fine. Just wanted to make sure we understood how it was being used.

A_SUSHMA · Post by **A_SUSHMA** » Tue Mar 04, 2014 12:34 am

Each time I need to reject a record or the record is bypassed then audit table is incremented. I am using the Routine KeyMgtGetNextValue
.I will call this function each time when the record is by passed or reject.once the process completed successfully.Next day when I want to run the process I want to reset the KeyMgtGetNextValue
Please let me know how to reset?

chulett · Post by **chulett** » Tue Mar 04, 2014 1:11 am

Asked and answered. There was a suggestion to search as you're not the first person to ask that question and I posted a link to one such search result. There are several.

A_SUSHMA · Post by **A_SUSHMA** » Tue Mar 04, 2014 1:14 am

I am asking how to reset the KeyMgtGetNextValue to ZERO, Once the process completed...

chulett · Post by **chulett** » Tue Mar 04, 2014 11:17 am

Did you get this working? If not, are you having an issue with the command itself (which a search would have turned up) or the actual means of how to incorporate it into your processing?

For the latter, it would seem like you could do this either at the very beginning or end of your processing. Do you have a single step that encompasses either end? You could do this 'Before Job' in the first step or 'After Job' in the last step. Or as part of a Sequence job if that is controlling things.