| Author |
Message
|
| Svp |
 Posted: Thu Mar 04, 2010 11:14 am Post subject: Rolling back message to input queue |
 |
|
Apprentice
Joined: 18 Feb 2010
Posts: 40
|
Hi Friends,
I have a requirement,it is to rollback a message to the input queue if the message flow's output queue's queue manager is down.
I dont want to implement backoutqueue and backoutthreshold.
Thanks in advance for your reply. |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Thu Mar 04, 2010 11:34 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Do you understand how WMQ Works? Especially with moving messages from one QM to the other?
Why do you want to block it in the flow?
Why not let WMQ handle the issue of the destination QM being down?
What about all the other possible errors that might stop the message from being delivered. Do you want to code for them as well?
Please take some time to answer at least some of the above. They should help you answer your question.
_________________
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 |
|
|
| Svp |
| Posted: Thu Mar 04, 2010 11:47 am Post subject: |
|
|
Apprentice
Joined: 18 Feb 2010
Posts: 40
|
Thanks. Your questions mean a lot.
I have another requirement which is to calculate yesterdays date using the current date. is it possible in ESQL?
If it is possible, please give me some hint to do that. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Mar 04, 2010 12:02 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Svp wrote: |
Thanks. Your questions mean a lot.
I have another requirement which is to calculate yesterdays date using the current date. is it possible in ESQL?
If it is possible, please give me some hint to do that. |
All the hints you need are in the INTERVAL data type.
Check out the ESQL Ref and handling dates in ESQL in the infocenter.
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Svp |
| Posted: Thu Mar 04, 2010 12:12 pm Post subject: |
|
|
Apprentice
Joined: 18 Feb 2010
Posts: 40
|
Thanks  |
|
| Back to top |
|
|
| Svp |
| Posted: Fri Mar 05, 2010 7:02 am Post subject: |
|
|
Apprentice
Joined: 18 Feb 2010
Posts: 40
|
I want to share what I found
CURRENT_DATE - CAST(1 AS INTERVAL DAY) returns Previous Day from the current date. |
|
| Back to top |
|
|
|
|
