| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| COALESCE(ASBITSTREAM(InputRoot)) Error while writing to DB2 |
« View previous topic :: View next topic » |
| Author |
Message
|
| vedantpatil |
 Posted: Thu Apr 21, 2005 6:22 am Post subject: COALESCE(ASBITSTREAM(InputRoot)) Error while writing to DB2 |
 |
|
Novice
Joined: 10 Mar 2005
Posts: 19
|
I am trying to insert the message as blob in error d2 when it fails to validate.
In compute node i am applying the domain and message set. and then it goes to MQOutput node where it fails due to invalid message. Failure terminal of MQOutput is connect to error handling copute node where i am updating the message to the error table.
i am getting the parsing error while updating the table.
updating code is given below
INSERT INTO Database.FCIBERRORS(MSGID,TEXT,ERRORNUM, ERRORDATE,MSGDATA,FLOWNAME,ERRORATNODE)
VALUES(CAST(InputRoot.MQMD.MsgId AS CHARACTER),Text,Error, CURRENT_TIMESTAMP,COALESCE(ASBITSTREAM(InputRoot)),FlowName,NodeName);
Can anybody give the solution.
Thanks in advance.
Vedant |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Apr 21, 2005 7:24 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you look at the syntax for the Coalesce statement?
Did you look at the syntax for the Asbitstream statement?
Can you post the exact error message that you are getting?
Are you sure that it is valid to use ASBITSTREAM on InputRoot?
_________________
I am *not* the model of the modern major general. |
|
| 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
|
|
|
|
