| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How many inserts can an user exception throw? |
« View previous topic :: View next topic » |
| Author |
Message
|
| simonalexander2005 |
 Posted: Thu Sep 14, 2017 7:42 am Post subject: How many inserts can an user exception throw? |
 |
|
Acolyte
Joined: 13 Jun 2016
Posts: 55
|
Given the following (so not creating a new message catalog):
| Code: |
| THROW USER EXCEPTION MESSAGE 3019 VALUES ('1','2','3',...) |
How many inserts is the maximum you can include?
The documentation for THROW (https://www.ibm.com/support/knowledgecenter/en/SSKM8N_8.0.0/com.ibm.etools.mft.doc/ak05150_.htm) doesn't give an explicit number except for lower message number ranges
| Quote: |
| Use the optional VALUES field to insert data into your message. You can insert any number of pieces of information, but the messages supplied (2951 - 2999) cater for eight inserts only. |
My understanding is that 3019 is still in a standard range, however; so can it have more than 8?
| Quote: |
| A fixed set of messages that are provided in the product message catalog. This set provides a range of numbers for Throw nodes (BIP3001 to BIP3049) |
(https://www.ibm.com/support/knowledgecenter/en/SSKM8N_8.0.0/com.ibm.etools.mft.doc/as04521_.htm) isn't clear on how many inserts can be used.
Also, is this only true for ESQL; or also for java? If I used MBUserException (https://www.ibm.com/support/knowledgecenter/en/SSKM8N_8.0.0/com.ibm.etools.mft.plugin.doc/com/ibm/broker/plugin/MbUserException.html), how many inserts could I include then? |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Sep 14, 2017 10:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The first part says that the log messages thrown to indicate an issue with a database call (BIP2951-BIP2999) only have inserts for up to eight insert values.
This only refers to the format of the information included with those BIP messages.
The second part indicates what messages can be produced by the Throw node.
Neither of these have anything to do with the code you write to interact with the database.
They only have to do with the log messages that broker produces.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| martinb |
| Posted: Thu Sep 14, 2017 11:38 pm Post subject: |
|
|
Master
Joined: 09 Nov 2006
Posts: 210
Location: UK
|
The important part is how many of the insert objects provided in the THROW etc will be formatted into the BIP message. You can review that with the 'mqsiexplain' command
For example BIP3019 has just 2 inserts it will display:
| Code: |
C:\Program Files\IBM\IIB\10.0.0.10>mqsiexplain 3019
BIP3019I: Exception thrown by throw node 'insert2'; text is 'insert1'.
The throw node 'insert2' has received a message and thus has thrown an exception as this is its normal behavior. The message text associated with this exception is 'insert1'.
Since this is application generated (by message flow behavior), the user actionis determined by the message flow and the type of exception generated.
|
While BIP2951 has 10 inserts it will display:
| Code: |
C:\Program Files\IBM\IIB\10.0.0.10>mqsiexplain BIP2951
BIP2951I: Event generated by user code. Additional information : 'insert1' 'insert2' 'insert3' 'insert4' 'insert5' 'insert6' 'insert7' 'insert8' 'insert9' 'inse
rt10'
The event was generated by an SQL LOG or THROW statement. This is the normal behavior of these statements.
Since this is a user generated event, the user action is determined by the message flow and the type of event.
|
|
|
| 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
|
|
|
|
