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 SupportESQL Namespace and FIELDVALUE

Post new topicReply to topic
ESQL Namespace and FIELDVALUE View previous topic :: View next topic
Author Message
Bichu
PostPosted: Fri Sep 18, 2020 2:35 am Post subject: ESQL Namespace and FIELDVALUE Reply with quote

Centurion

Joined: 16 Oct 2011
Posts: 124
Location: London

Hello Guys,
I need a help. I am having the below ESQL code to populate a value

Code:

DECLARE inEnvRef REFERENCE TO Environment.Request;
DECLARE inPolicyRef REFERENCE TO inEnvRef.ns:Policy;

DECLARE outRef REFERENCE TO OutputRoot.SOAP.Body.ns3:parentElement;
DECLARE outPolicyRef REFERENCE TO outRef.ns3:PolicyComplexElement;
SET outPolicyRef.ns504:PolicyNumber = inPolicyRef.ns306:PolicyNumber;


After executing these elements PolicyNumber under outPolicyRef is not having any value in the XML tree. I put a file trace after this Compute node and found the below line

Code:

(0x03000000:PCDataField)http://outputMessageNamespaceGoesHere:PolicyNumber              = '8566001794362' (CHARACTER)
          (
            (0x03000102:NamespaceDecl):xmlns = 'http://inputMessageNamespaceGoesHere' (CHARACTER)
          )

And when i altered from

Code:

SET outPolicyRef.ns504:PolicyNumber = inPolicyRef.ns306:PolicyNumber;
to
Code:
SET outPolicyRef.ns504:PolicyNumber = FIELDVALUE(inPolicyRef.ns306:PolicyNumber);


The problem is that i need to give now fieldvalue for 300+ fields. Is it something wrong i am doing on the SET statement I can easily fix or FIELDVALUE is the fix.
And any thoughts on what is happening internally here
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Fri Sep 18, 2020 3:35 am Post subject: Reply with quote

Partisan

Joined: 17 Jul 2017
Posts: 381
Location: UK

hi...

Code:
a=b
means the whole element/structure will get copied from b to a including attributes of element b and its value.

Code:
a=FIELDVALUE(b)
means you only want to copy the value of element b to a.

so is your intention to copy the whole element as-is or just its value? if it is just the value and it makes sense to use FIELDVALUE so that the intention is clear.
Back to top
View user's profile Send private message
Bichu
PostPosted: Fri Sep 18, 2020 3:41 am Post subject: Reply with quote

Centurion

Joined: 16 Oct 2011
Posts: 124
Location: London

My intention is to copy the value here but i have same kind of statements for other fields where the value is getting copied. So wondering why very few elements are not getting copied.
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Fri Sep 18, 2020 5:14 am Post subject: Reply with quote

Partisan

Joined: 17 Jul 2017
Posts: 381
Location: UK

Bichu wrote:
My intention is to copy the value here but i have same kind of statements for other fields where the value is getting copied. So wondering why very few elements are not getting copied.


you will only see the difference for complex elements, i.e ones with value and attributes, for simple elements a=b will just do the same as a=FIELDVALUE(b)

can you post the sample input element structure you are trying to copy across, also run the flow user trace which should show what exactly is happening.
Back to top
View user's profile Send private message
Bichu
PostPosted: Fri Sep 18, 2020 9:12 am Post subject: Reply with quote

Centurion

Joined: 16 Oct 2011
Posts: 124
Location: London

Thanks for the idea of usertrace.

Below is the usertrace I got.

Code:

2020-09-18 19:38:12.818626    17044   UserTrace   BIP2537I: Node 'com.soa.Application_Name.BuildRequest': Executing statement   ''IF outPolicyDTORef.ns504:PolicyNumber IS NULL OR outPolicyDTORef.ns504:PolicyNumber = '' THEN... END IF;'' at ('com.soa.Application_Name_CreateRequest.Main', '535.3').
2020-09-18 19:38:12.818634    17044   UserTrace   BIP2539I: Node '': Evaluating expression ''outPolicyDTORef.ns504:PolicyNumber'' at ('com.soa.Application_Name_CreateRequest.Main', '535.7'). This resolved to ''outPolicyDTORef.http://ouputMessageNameSpace:PolicyNumber''. The result was ''''''.
2020-09-18 19:38:12.818640    17044   UserTrace   BIP2540I: Node '': Finished evaluating expression ''outPolicyDTORef.ns504:PolicyNumber IS NULL'' at ('com.soa.Application_Name_CreateRequest.Main', '535.42'). The result was ''FALSE''.
2020-09-18 19:38:12.818649    17044   UserTrace   BIP2539I: Node '': Evaluating expression ''outPolicyDTORef.ns504:PolicyNumber'' at ('com.soa.Application_Name_CreateRequest.Main', '535.55'). This resolved to ''outPolicyDTORef.http://ouputMessageNameSpace:PolicyNumber''. The result was ''ROW... Root Element Type=16777216 NameSpace='http://ouputMessageNameSpace' Name='PolicyNumber' Value=''''.
2020-09-18 19:38:12.818659    17044   UserTrace   BIP2539I: Node '': Evaluating expression ''outPolicyDTORef.ns504:PolicyNumber = '''' at ('com.soa.Application_Name_CreateRequest.Main', '535.90'). This resolved to ''ROW... Root Element Type=16777216 NameSpace='http://ouputMessageNameSpace' Name='PolicyNumber' Value='' = ''''. The result was ''TRUE''.
2020-09-18 19:38:12.818667    17044   UserTrace   BIP2539I: Node '': Evaluating expression ''outPolicyDTORef.ns504:PolicyNumber IS NULL OR outPolicyDTORef.ns504:PolicyNumber = '''' at ('com.soa.Application_Name_CreateRequest.Main', '535.51'). This resolved to ''FALSE OR TRUE''. The result was ''TRUE''.
2020-09-18 19:38:12.818677    17044   UserTrace   BIP2537I: Node 'com.soa.Application_Name.BuildRequest': Executing statement   ''SET outPolicyDTORef.ns504:PolicyNumber = inPolicyRef.ns306:PolicyNumber;'' at ('com.soa.Application_Name_CreateRequest.Main', '536.4').
2020-09-18 19:38:12.818687    17044   UserTrace   BIP2539I: Node '': Evaluating expression ''inPolicyRef.ns306:PolicyNumber'' at ('com.soa.Application_Name_CreateRequest.Main', '536.45'). This resolved to ''inPolicyRef.http://inputMessageNamespace:PolicyNumber''. The result was ''ROW... Root Element Type=50331648 NameSpace='http://inputMessageNamespace' Name='PolicyNumber' Value='8566001794362'''.
2020-09-18 19:38:12.818695    17044   UserTrace   BIP2568I: Node 'com.soa.Application_Name.BuildRequest': Copying sub-tree from ''inPolicyRef.ns306:PolicyNumber'' to ''outPolicyDTORef.ns504:PolicyNumber''.


Copying is successful. But it also says its copying a subtree as well. Will that be a pblm? Because I could see the value in the filetrace as well.
Back to top
View user's profile Send private message
timber
PostPosted: Fri Sep 18, 2020 2:21 pm Post subject: Reply with quote

Grand Master

Joined: 25 Aug 2015
Posts: 1138

I think I remember this problem.

The issue arises because you have a tag which has both a value and a child node (the namespace declaration). I seem to remember that this causes problems with the default tree-copy algorithm used in the XMLNSC parser. A quick search for 'XMLNSC FIELDVALUE empty' confirms that there have been fixes, but any recent version of IIB/ACE will contain all of the fixes.

Somebody else might remember how to work around this. If not, you may want to ask IBM for assistance. If you do, it will be worthwhile to mention the URL of this thread in the problem description.
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Sat Sep 19, 2020 3:25 am Post subject: Reply with quote

Partisan

Joined: 17 Jul 2017
Posts: 381
Location: UK

Bichu wrote:

Code:

This resolved to ''inPolicyRef.http://inputMessageNamespace:PolicyNumber''. The result was ''ROW... Root Element Type=50331648 NameSpace='http://inputMessageNamespace' Name='PolicyNumber' Value='8566001794362'''.


Copying is successful. But it also says its copying a subtree as well. Will that be a pblm? Because I could see the value in the filetrace as well.


hi...i think that is working as designed, i.e it will copy the whole subtree at input PolicyNumber element including its valid, namespace child and any other subtree under it. In such scenarios if you are just after the value then using FIELDVALUE is the way to go.
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Sat Sep 19, 2020 3:27 am Post subject: Reply with quote

Partisan

Joined: 17 Jul 2017
Posts: 381
Location: UK

timber wrote:
A quick search for 'XMLNSC FIELDVALUE empty' confirms that there have been fixes


hi timber...I think the OP is not saying that FIELDVALUE is not working, instead he is expecting 'a=b' to copy just the value of 'b' to 'a' instead of the whole 'b' subtree.
Back to top
View user's profile Send private message
timber
PostPosted: Sat Sep 19, 2020 3:02 pm Post subject: Reply with quote

Grand Master

Joined: 25 Aug 2015
Posts: 1138

@abhi_thri: Are you sure? The initial problem statement seems quite clear to me.
Bichu does not mention the copying of the subtree. He is reporting that the value of inPolicyRef.ns306:PolicyNumber is not being copied at all unless he uses FIELDVALUE.
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Sun Sep 20, 2020 3:08 am Post subject: Reply with quote

Partisan

Joined: 17 Jul 2017
Posts: 381
Location: UK

timber wrote:
@abhi_thri: Are you sure? The initial problem statement seems quite clear to me.
Bichu does not mention the copying of the subtree. He is reporting that the value of inPolicyRef.ns306:PolicyNumber is not being copied at all unless he uses FIELDVALUE.


hi timber,
yes, initially he reported that the value is not coming across but that doesn't seems to tie up with the trace output log,

Code:

(0x03000000:PCDataField)http://outputMessageNamespaceGoesHere:PolicyNumber              = '8566001794362' (CHARACTER)
          (
            (0x03000102:NamespaceDecl):xmlns = 'http://inputMessageNamespaceGoesHere' (CHARACTER)
          )


The trace log suggests that the whole sub-tree is getting copied across including the value.

Later the user trace tells the same story,

Code:
2020-09-18 19:38:12.818687    17044   UserTrace   BIP2539I: Node '': Evaluating expression ''inPolicyRef.ns306:PolicyNumber'' at ('com.soa.Application_Name_CreateRequest.Main', '536.45'). This resolved to ''inPolicyRef.http://inputMessageNamespace:PolicyNumber''. The result was ''ROW... Root Element Type=50331648 NameSpace='http://inputMessageNamespace' Name='PolicyNumber' Value='8566001794362'''.
2020-09-18 19:38:12.818695    17044   UserTrace   BIP2568I: Node 'com.soa.Application_Name.BuildRequest': Copying sub-tree from ''inPolicyRef.ns306:PolicyNumber'' to ''outPolicyDTORef.ns504:PolicyNumber''.


and in the later post he is saying that the copying worked,

Bichu wrote:
Copying is successful. But it also says its copying a subtree as well. Will that be a pblm? Because I could see the value in the filetrace as well.
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 SupportESQL Namespace and FIELDVALUE
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.