UUIDASCHAR generates a 36 character string , you could trim the last 5 characters and hope as hell that this function does not generate a duplicate ending 5 characters in one day.
Just trying to understand option #3, the message in the queue would always contain the latest transaction # is it ? And every time you consume, you create a new message with the incremented value of the counter and place it on the queue again ?
Create a another broker flow or external program which will run every x number of minutes and creates x number of messages with a unique transaction number and place them in a queue.
The other broker flows which requires a transaction number could use a MQGet to consume a transaction number.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum