I ma having a problem retrieving a value from a database.

Bsaically I have built my own custom EDI maps.  These do not use the
EDI adapter which means I need to create a way to store and increment
control number values.  I do this by having the orchestration send a
message to a SQL server adapter which triggers a stored procedure.
Then the map retrieves the new value.

However, all of the files translated come out with the latest updated
value for the control number.  For example, if I drop two files into
my pickup directory and the control number has a value of 20, then
both resulting EDI files have a control number of 22.  I thought an
orchestration processed one message at a time.  What am I missing and
how do I handle it?

Thanks,
Nathan

[ Post a follow-up to this message ]