| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| How to Decode the Xml value from the Blob filed |
« View previous topic :: View next topic » |
| Author |
Message
|
| Laaziya |
 Posted: Thu Mar 13, 2014 1:50 am Post subject: |
 |
|
Novice
Joined: 05 Mar 2014
Posts: 13
|
SET Environment.Outbound.claim= PASSTHRU('SELECT XML_IN FROM CLAIM_XML WHERE CLM_RECRD_ID =?',Id);
DECLARE bodyBlob BLOB ASBITSTREAM(InputRoot.XMLNS, InputProperties.Encoding,InputProperties.CodedCharSetId);
CREATE FIELD Environment.Outbound.claim;
DECLARE creationPtr REFERENCE TO Environment.Outbound.claim;
CREATE FIRSTCHILD OF creationPtr DOMAIN('XMLNS') PARSE(bodyBlob,
InputProperties.Encoding,
InputProperties.CodedCharSetId);
Let me know if im wrong in this code. This code results error. |
|
| Back to top |
|
 |
| Esa |
| Posted: Thu Mar 13, 2014 2:26 am Post subject: |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
| Laaziya wrote: |
Let me know if im wrong in this code. This code results error. |
1. PASSTHRU returns an array.
2. Why do you try to parse the Input message into BLOB and then back to a message tree? Shouldn't you process the result of the db query instead?
3. Use XMLNSC, not XMLNS. |
|
| Back to top |
|
|
| Laaziya |
| Posted: Thu Mar 13, 2014 4:20 am Post subject: |
|
|
Novice
Joined: 05 Mar 2014
Posts: 13
|
It doesn't work. I tried out to change the flow too . Did work  |
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Thu Mar 13, 2014 5:02 am Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
| Laaziya wrote: |
| This code results error. |
Yes... And then? What's the error, for instance? What does the documentation say about this error?
_________________
A measure of wheat for a penny, and three measures of barley for a penny; and see thou hurt not the oil and the wine. |
|
| Back to top |
|
|
| Laaziya |
| Posted: Thu Mar 13, 2014 5:22 am Post subject: |
|
|
Novice
Joined: 05 Mar 2014
Posts: 13
|
x03000000:NameValue):Text = 'Error detected, rethrowing' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'POSTPAY.OUT_WTX_INTG_Compute3.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '46.6' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'CREATE FIRSTCHILD OF creationPtr DOMAIN 'XMLNS' PARSE(bodyBlob,
InputProperties.Encoding, InputProperties.CodedCharSetId);' (CHARACTER)
)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = '/build/slot1/S800_P/src/DataFlowEngine/ImbRdl/ImbRdlTreeStatements.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 191 (INTEGER)
(0x03000000:NameValue):Function = 'SqlCreateFieldStatement::execute' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'POSTPAY/OUT_WTX_INTG#FCMComposite_1_8' (CHARACTER)
(0x03000000:NameValue):Label = 'POSTPAY.OUT_WTX_INTG.OutboundXML' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2906 (INTEGER)
(0x03000000:NameValue):Text = '' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'POSTPAY.OUT_WTX_INTG_Compute3.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '46.6' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'NULL' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'BITSTREAM' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'CREATE' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'CHARACTER, BIT, BLOB' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'NULL' (CHARACTER)
)
)
Ended with this one in trace |
|
| Back to top |
|
|
| Esa |
| Posted: Thu Mar 13, 2014 5:40 am Post subject: |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
You can check the error message here
Your code is a direct copy of example 7 of CREATE statement in the Infocenter.
Why doesn't it 'work', then?
Are you sure that InputRoot.XMLNS exists?
Yes, fix this and next you will find out that you have processed the wrong message. |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
