| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| CREATE Statement |
« View previous topic :: View next topic » |
| Author |
Message
|
| gag_nm |
 Posted: Fri Feb 15, 2013 7:52 am Post subject: CREATE Statement |
 |
|
Centurion
Joined: 16 Oct 2008
Posts: 102
|
Below is the input XML
<A>1234</A>
<B>321</B>
and i am trying to create new field using below code..
| Code: |
DECLARE cursor REFERENCE TO OutputRoot.MRM;
SET TAGVALUE = FIELDVALUE(InputRoot.XMLNSC.(XML.Attribute)A);
Here value TAGVALUE is 123
CREATE LASTCHILD OF cursor Domain('MRM') NAME 'Account' VALUE TAGVALUE;
when i trying to create field using above code i am receiving null in Value field...
<Account></Account>
|
can some tell where i went wrong ?? |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Fri Feb 15, 2013 8:01 am Post subject: Re: CREATE Statement |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| gag_nm wrote: |
| can some tell where i went wrong ?? |
1. Attend the required product training.
2. You have not specified the problem fully. What is the four-digit version number of the runtime? What is the effective level of the runtime?
3. You may prefer to use the XMLNSC parser rather than MRM. Although, your initial information doesn't say alot about why you chose MRM, which may be a valid (or not) choice based on your requirement.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 15, 2013 8:15 am Post subject: Re: CREATE Statement |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| gag_nm wrote: |
| can some tell where i went wrong ?? |
Well in the XML you quoted A isn't an attribute, it's the tag value & even if it is an attribute in the real XML you'd specify it with XMLNSC.Attribute not XML.Attribute.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| adubya |
| Posted: Fri Feb 15, 2013 9:06 am Post subject: |
|
|
Partisan
Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK
|
|
| Back to top |
|
|
| kimbert |
| Posted: Fri Feb 15, 2013 9:10 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
So far, you have posted
- some broken XML ( no root tag )
- some broken ESQL ( XML.Attribute instead of XMLNSC.Attribute )
- more broken ESQL ( A is a tag, not an attribute )
...and no indication of what your task is.
Please start by telling us what you are trying to do. It's quite difficult to work that out so far...  |
|
| 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
|
|
|
|
