SQL update field to next number, then return value
Posted on 2006-05-15
I am working on a application for moving items around in our warehouse, and I need to assign a batch number for the inventory transaction. I need to lookup a value in our J.D. Edwards database to get the next number, then increment it and for the next person.
I can do this in two statements, but I want to do it in one so that the select and update happen at the same time so I do not have to worry about another user incrementing the number at the same time.
Anyone have experience with that type of statement?
Thanks in advance.
ISeries V5R3M0, J.D. Edwards 8.10