| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| REFERENCE path to CHARACTER? |
« View previous topic :: View next topic » |
| Author |
Message
|
| gechu |
 Posted: Thu Dec 23, 2010 1:19 am Post subject: REFERENCE path to CHARACTER? |
 |
|
Apprentice
Joined: 27 Feb 2008
Posts: 48
|
I´m using the DataInsert node where I need to feed a function which holds a SELECT statement.
The SELECT statements expects a FIELD REFERENCE[] in the FROM clause. Problem is that I have to construct a long string with the entire SELECT statement, and then run it through EVAL.
And I can´t extract the CHARACTER representation of the REFERENCE variable´s path.
So I don´t want what the REFERENCE pointer is set at,, I just want the entire name of the REFERENCE. I.e. InputRoot.XMLNSC.myMessage.SegmentA
Is that possible?
EDIT:
settled on another solution. Now a new problem.
REFERENCE is passed to a function, how do I change myRef to myRef[]?
Thanks!
Erik |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Dec 23, 2010 5:02 am Post subject: Re: REFERENCE path to CHARACTER? |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| gechu wrote: |
| REFERENCE is passed to a function, how do I change myRef to myRef[]? |
How do you see them as different?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| gechu |
| Posted: Thu Dec 23, 2010 6:40 am Post subject: |
|
|
Apprentice
Joined: 27 Feb 2008
Posts: 48
|
The problem was poorly described. Sorry for that.
Luckily I´ve just solved the problem. Here is a better explanation of the problem
The data structure might look like this:
A
B
--B1
--B1
B
--B1
--B1
C
D
I want to look in every B1 for each B,, for a certain value.
I let the DataInsert node take care of the cardinalities using FOR. So, FOR each B, check if any B1 satisfies my condition.
To let the SELECT statement walk through all instances of B1 under a certain B, I have to specify B.B1[] in the FROM clause.
The actual ESQL FROM clause looks like this
FROM inParentSegment.{inChildSegment}[]
inParentSegment is a Reference
inChildSegment is a string which holds my loop element. (Element B1 in the example).
Not sure about the syntax. But it works the way it is right now. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Dec 23, 2010 7:08 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| gechu wrote: |
| Luckily I´ve just solved the problem. |
This is always a good thing.
| gechu wrote: |
| But it works the way it is right now. |
Again a good thing, and thank you for posting your solution.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| 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
|
|
|
|
