DSXchange

Hi All,


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

Search for "UPDATE SDKSequences"

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?

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

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

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?

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.

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

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.