ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportHow to access to second XMLNSC folder on ESQL

Post new topicReply to topic
How to access to second XMLNSC folder on ESQL View previous topic :: View next topic
Author Message
ccarrillo
PostPosted: Thu Oct 11, 2018 1:12 pm Post subject: How to access to second XMLNSC folder on ESQL Reply with quote

Newbie

Joined: 28 Oct 2016
Posts: 7

I'm trying to acces at the second XMLNSC folder with ESQL language, but is return null.

Code:
Message
   XMLNSC
         SubFlow1...         
   XMLNSC
         SubFlow2...


this is my code:

Code:
BROKER SCHEMA pe.gob.prueba

DECLARE ns4 NAMESPACE 'http://www.cnxav/SubFlow1.xsd';
DECLARE ns NAMESPACE 'http://www.cnxav/SubFlow2.xsd';


CREATE COMPUTE MODULE AfiliacionOnline_Compute5
   CREATE FUNCTION Main() RETURNS BOOLEAN
   BEGIN


      DECLARE value CHAR ;
      

      SET value = InputRoot.XMLNSC.ns:SubFlow2.txError;



Please any sugesstion?
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Oct 11, 2018 7:49 pm Post subject: Reply with quote

Grand Poobah

Joined: 18 Nov 2003
Posts: 19758
Location: LI,NY

Perhaps a complete misunderstanding of what a message should look like?

I'm thinking

Code:

Message
             XMLNSC
                    <root_tag>
                            <subflow1 tag/>
                            <subflow2 tag/>
                    </root_tag>


Hope it helps :innocent;
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
ccarrillo
PostPosted: Fri Oct 12, 2018 5:48 am Post subject: How to access to second XMLNSC folder on ESQL Reply with quote

Newbie

Joined: 28 Oct 2016
Posts: 7

Yes, I know that, but my question is, what happen if , i've two XMLNSC folder, like this:

Code:
WMQI_Message

   XMLNSC
         SubFlow1
               txError
   XMLNSC
         SubFlow2
                         txError


Can I access at the second? or neccesarily only one is allowed?
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Sat Oct 13, 2018 11:16 am Post subject: Re: How to access to second XMLNSC folder on ESQL Reply with quote

Grand Poobah

Joined: 18 Nov 2003
Posts: 19758
Location: LI,NY

ccarrillo wrote:
Yes, I know that, but my question is, what happen if , i've two XMLNSC folder, like this:

Code:
WMQI_Message

   XMLNSC
         SubFlow1
               txError
   XMLNSC
         SubFlow2
                         txError


Can I access at the second? or neccesarily only one is allowed?


Then you have a mess on your hands and not a message...
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
souciance
PostPosted: Sun Oct 14, 2018 12:56 am Post subject: Re: How to access to second XMLNSC folder on ESQL Reply with quote

Disciple

Joined: 29 Jun 2010
Posts: 158

ccarrillo wrote:
I'm trying to acces at the second XMLNSC folder with ESQL language, but is return null.

Code:
Message
   XMLNSC
         SubFlow1...         
   XMLNSC
         SubFlow2...


this is my code:

Code:
BROKER SCHEMA pe.gob.prueba

DECLARE ns4 NAMESPACE 'http://www.cnxav/SubFlow1.xsd';
DECLARE ns NAMESPACE 'http://www.cnxav/SubFlow2.xsd';


CREATE COMPUTE MODULE AfiliacionOnline_Compute5
   CREATE FUNCTION Main() RETURNS BOOLEAN
   BEGIN


      DECLARE value CHAR ;
      

      SET value = InputRoot.XMLNSC.ns:SubFlow2.txError;



Please any sugesstion?


Why don't you store the second XMLNSC folder in the Environment tree and access it from there?
Back to top
View user's profile Send private message
rekarm01
PostPosted: Mon Oct 15, 2018 8:03 am Post subject: Re: How to access to second XMLNSC folder on ESQL Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 1306

Aside from any questionable design issues,

ccarrillo wrote:
Please any sugesstion?

try something like this:

Code:
SET value = InputRoot.XMLNSC[2].ns:SubFlow2.txError;
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportHow to access to second XMLNSC folder on ESQL
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.