Getting current value from SDKSequences

[sbass1]

In Routines\SDK\KeyMgt, we have KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, but no KeyMgtGetCurrentValue (i.e. no increment).

Is this as simple as creating a transform such as:

UtilityHashLookup("SDKSequences",<desired key>,"")

It needs to run concurrently, but is just a read not an update.

I tested this in a snippet of BASIC code and it worked OK...just checking if this is best practice and no concurrency issues.

[chulett]

You'll be fine, but I'd suggest you actually create your KeyMgtGetCurrentValue routine (from the non-concurrent 'next value' version) just from the standpoint of it being more obvious what is going on.

[ray.wurlod]

Or you can simply use a Hashed File stage pointed at SDKSequences with "made up" metadata - one VarChar (key) column and one integer column.