Author |
Message
|
ghoose |
Posted: Wed Dec 10, 2003 5:01 am Post subject: Parsing XML to Blob without RCD |
|
|
Novice
Joined: 23 Apr 2002 Posts: 16
|
Hi,
I am trying to parse the input xml to Blob without using a RCD node. Below is the line of ESQL i am using and the out put of the same in a trace node.
you can see that im not getting any data atall.
When i replace the Compute node(with the below statement) with RCD im getting expected data.
I am not sure if im doing any thing wrong in the code.
Please advice.
Thanks
Ghoose!
Code: |
CREATE FIRSTCHILD OF OutputRoot.BLOB DOMAIN 'BLOB' PARSE(InputRoot.XML.AppSvrTxn,273,819); |
)
Quote: |
(0x1000000)BLOB = (
(0x1000000)BLOB = (
(0x3000000)BLOB = X''
)
)
) |
|
|
Back to top |
|
 |
kirani |
Posted: Wed Dec 10, 2003 11:38 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
|
Try this,
Code: |
SET OutputRoot."BLOB"."BLOB" = BITSTREAM(InputRoot.XML);
|
_________________ 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 |
|
 |
mgk |
Posted: Wed Dec 10, 2003 12:17 pm Post subject: |
|
|
 Padawan
Joined: 31 Jul 2003 Posts: 1642
|
CREATE with the PARSE clause is designed for creating elements in the tree from a bitstream, not the other way around. You can either use the BITSTREAM or ASBITSTREAM functions to do what you want. _________________ MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
Back to top |
|
 |
jefflowrey |
Posted: Wed Dec 10, 2003 1:24 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
If you are using 2.1 later than CS03, you should be using the ASBITSTREAM function, not the BITSTREAM function.
If you are using 2.1 earlier than CSD03, you should upgrade to at least CSD04...  _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
ghoose |
Posted: Thu Dec 11, 2003 9:19 am Post subject: |
|
|
Novice
Joined: 23 Apr 2002 Posts: 16
|
Thanks guys. I will give it a try and let you know |
|
Back to top |
|
 |
Sandman |
Posted: Thu Apr 29, 2004 9:34 am Post subject: |
|
|
Centurion
Joined: 16 Oct 2001 Posts: 134 Location: Lincoln, RI
|
jefflowrey wrote: |
If you are using 2.1 later than CS03, you should be using the ASBITSTREAM function, not the BITSTREAM function.
If you are using 2.1 earlier than CSD03, you should upgrade to at least CSD04...  |
Can someone please point me to some documentation on this ASBITSTREAM?
Thanks. |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Apr 29, 2004 9:48 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
It's in the memo.ptf for CSD03 or greater. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
Sandman |
Posted: Thu Apr 29, 2004 9:51 am Post subject: |
|
|
Centurion
Joined: 16 Oct 2001 Posts: 134 Location: Lincoln, RI
|
jefflowrey wrote: |
It's in the memo.ptf for CSD03 or greater. |
Thanks Jeff. |
|
Back to top |
|
 |
|