| Author |
Message
|
| pfaulkner |
 Posted: Wed Sep 24, 2003 12:51 pm Post subject: getting a MQ Reason Code with ESQL |
 |
|
Master
Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA
|
| How can I get the MQ Reason Code in my ESQL after a MQ Put failed? |
|
| Back to top |
|
 |
| kirani |
| Posted: Wed Sep 24, 2003 3:29 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
MQ Reason code is populated in your ExceptionList. So you can get this value by investigating the ExceptionList.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| pfaulkner |
| Posted: Wed Sep 24, 2003 5:55 pm Post subject: |
|
|
Master
Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA
|
| I haven't found a way to parse the Exception List inteligently. Do you know a way? I know how to traverse thru the structure looking the inner most exception but then all the details seem to be stored in <Insert> tags with type 5 for String and 2 for Integers but I don't see anything that tells you what the actual field is. |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Sep 25, 2003 4:29 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
They have a sample code in ESQL Reference manual to parse the ExceptionList to get Error Codes, see if that helps you. Please refer to Appendix A - Example exception lists.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| pfaulkner |
| Posted: Fri Sep 26, 2003 6:58 am Post subject: |
|
|
Master
Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA
|
Yeah I had already seen that but what I was looking for was something that would explain a little more detail...like:
What are the text fields within the Insert tags? They seem to represent Strings and Integers based on the Type tag but what it doesn't tell you is what the fields actually represent (e.g., MQ Reason Code, or Field Name). This makes it impossible to pull out relevent information from these structures. The second example in Appendix A is a good example of this (page 132). It has 9 Insert tags, 4 of which have Text data but there is no way of knowing what the text refers to.
Page 133 talks about the need to retrieve the error code from the inner most exception in the list and the example on Page 128 has this text
"This identifies error number 2450 that indicates that the node has attempted to divide by zero."
But where are these error codes documented? |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Sep 26, 2003 7:04 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
| pfaulkner wrote: |
But where are these error codes documented? |
WMQI - Messages manual.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| pfaulkner |
| Posted: Fri Sep 26, 2003 7:21 am Post subject: |
|
|
Master
Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA
|
Sorry, I had searched on '2450' in the example and didn't find anything. But found it when I searched on BIP2450.
thanks |
|
| Back to top |
|
|
|
|
