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 Index » WebSphere Message Broker (ACE) Support » how to view mapping node's ESQL code?

Post new topic  Reply to topic
 how to view mapping node's ESQL code? « View previous topic :: View next topic » 
Author Message
pcelari
PostPosted: Wed Jan 24, 2007 5:44 am    Post subject: how to view mapping node's ESQL code? Reply with quote

Chevalier

Joined: 31 Mar 2006
Posts: 411
Location: New York

I'm trying to understand how namespace is handled in compute node.

My input msg is TDS, output is an MRM (XML1), with target namespace http://ws.ei.myco.com/MC.

I use a compute node to assign fields.

SET OutputRoot.XML1.Message.MessageHeader.ServiceName=
InputRoot.ServiceName;

However, I got exception "Failed to locate constant".

I do have a working msgflow using mapping node. So I would like to see the ESQL code that performs the mapping. How can I view the ESQL code of a mapping node?

thanks,
_________________
pcelari
-----------------------------------------
- a master of always being a newbie
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Wed Jan 24, 2007 5:54 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Why would you possibly use "OutputRoot.XML1"?
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
pcelari
PostPosted: Wed Jan 24, 2007 6:35 am    Post subject: Reply with quote

Chevalier

Joined: 31 Mar 2006
Posts: 411
Location: New York

jefflowrey wrote:
Why would you possibly use "OutputRoot.XML1"?


thanks for pointing right to the cause. a true GM. I removed XML1 and use the following:

SET OutputRoot.mc:Message.MessageHeader.ServiceName=
InputRoot.ServiceName;

this successfully assigned part of the input to Message.MRM.ServiceName. I wonder why if I have to put that "mc:" in front of every node in the tree for it to assign value to the right destination node.
_________________
pcelari
-----------------------------------------
- a master of always being a newbie
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Wed Jan 24, 2007 6:53 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

You need to use OutputRoot.MRM.

Then you need to properly identify your fields, which includes qualifying them with namespaces if they are namespace qualified.

http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/ac06010_.htm
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
pcelari
PostPosted: Wed Jan 24, 2007 11:36 am    Post subject: Reply with quote

Chevalier

Joined: 31 Mar 2006
Posts: 411
Location: New York

many thanks for the link. Following it, I understand that I need to declare namespace at ESQL code level when the msgset is namespace enabled - my case.

here's my code:

...
declare mc name space 'http://ei.myco.com/MC';

SET OutputRoot.mc:Message.mc:MessageHeader.mb:BusinessService=InputBody.ServiceName;

However, I got recoverable exception, with
Text=Failed to locate constant
insert.Text=Message

I don't get why "Message" is singled out.

Here's my envelop for the output msg:
<?xml version="1.0" encoding="UTF-8"?>
<mc:Message xmlns:mc="http://ei.myco.com/MC" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<mc:MessageHeader>
<mc:BusinessService></mc:BusinessService>
<mc:ServiceProvider></mc:ServiceProvider>
</mc:MessageHeader>
<mc:BusinessData>
</mc:BusinessData>
</mc:Message>
_________________
pcelari
-----------------------------------------
- a master of always being a newbie
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Wed Jan 24, 2007 11:48 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Because you have to use OutputRoot.MRM!

Set OutputRoot.MRM.mc:Message.mc:MessageHeader...

Or possibly OutputRoot.MRM.mc:MessageHeader....


_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
pcelari
PostPosted: Wed Jan 24, 2007 12:30 pm    Post subject: Reply with quote

Chevalier

Joined: 31 Mar 2006
Posts: 411
Location: New York

I tried that as well, but I got warning from problem pane:

Unresolvable message field reference "OutputRoot.MRM.mb:Message ...

anything else could I be missing?

thanks a lot.
_________________
pcelari
-----------------------------------------
- a master of always being a newbie
Back to top
View user's profile Send private message
sarat
PostPosted: Wed Jan 24, 2007 10:29 pm    Post subject: Reply with quote

Centurion

Joined: 29 Jun 2005
Posts: 136
Location: India

Igore the warnings..it'll show while using MRM!!!
_________________
With Regards,
Sarat.
Back to top
View user's profile Send private message
pcelari
PostPosted: Thu Jan 25, 2007 8:29 am    Post subject: Reply with quote

Chevalier

Joined: 31 Mar 2006
Posts: 411
Location: New York

thanks for the tip. Yes, just ignoring it did the trick.

I wonder why should there be warning in the first place.
_________________
pcelari
-----------------------------------------
- a master of always being a newbie
Back to top
View user's profile Send private message
elvis_gn
PostPosted: Thu Jan 25, 2007 9:08 am    Post subject: Reply with quote

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi pcelari,

http://www.mqseries.net/phpBB2/viewtopic.php?t=30049&highlight=warnings

Regards.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to view mapping node's ESQL code?
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.