| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Create incremental value for each batch in ESQL/message flow |
« View previous topic :: View next topic » |
| Author |
Message
|
| CuriCAT |
 Posted: Sun Nov 16, 2014 7:55 am Post subject: Create incremental value for each batch in ESQL/message flow |
 |
|
Voyager
Joined: 26 Sep 2006
Posts: 82
|
There is a requirement to create incremental value for each batch. The flow process files( input to flow is file and output is file), for each file processing flow has to assign unique/incremental value .
is there any esql function to perform this activity or message definition feature. one constrain is that, java compute node or java classes should not be used.
what logic people commonly use to create incremental number just using ESQL and compute nodes or message definitions. Can you please help me. |
|
| Back to top |
|
 |
| nelson |
| Posted: Sun Nov 16, 2014 8:08 am Post subject: |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
| What about UUIDASCHAR function? |
|
| Back to top |
|
|
| CuriCAT |
| Posted: Sun Nov 16, 2014 9:26 am Post subject: |
|
|
Voyager
Joined: 26 Sep 2006
Posts: 82
|
That will work, ofcource.Thank you!
Paricularly, we are looking for incremental value assigned to batch.
I have asked not to use DB or JAVA COMPUTE NODE or JAVA. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sun Nov 16, 2014 11:03 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| CuriCAT wrote: |
I have asked not to use DB |
What reason was given for not using a DB table?
IMHO, you have to use some form of storage to hole incrementing numbers over a broker failure/restart.
A simple DB table is ideal for this purpose.We use it all the time. Simples.
One of our systems has just clocked up it's 10,000,000 th message.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
