| Author |
Message |
 Topic: SELECT function to select message parts in compute node |
ltopa
Replies: 12
Views: 8279
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 26, 2007 5:42 am Subject: SELECT function to select message parts in compute node |
mgk: thanks for your reply. I'm using inStr.INSTRUMENT_ID and it works just fine.
Back to another question I had in my original post. Is there a way to use the SELECT function with the IN clause wh ... |
| Topic: SELECT function to select message parts in compute node |
ltopa
Replies: 12
Views: 8279
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 12, 2007 4:24 pm Subject: SELECT function to select message parts in compute node |
I think I got it... It was my FOR loop: looking at the ${Environment} trace, I see that instrId is still a list. If I change my assignment for myId to something like this:
SET myId = instrId.INSTRUME ... |
| Topic: SELECT function to select message parts in compute node |
ltopa
Replies: 12
Views: 8279
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 12, 2007 4:00 pm Subject: SELECT function to select message parts in compute node |
funny, posting function on this forum seems to choke if I have the word PASSTHR+U in my text (take the + sign out)...
Also can you post your Compute node code in full (as I want to see how you set ... |
| Topic: SELECT function to select message parts in compute node |
ltopa
Replies: 12
Views: 8279
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 12, 2007 3:48 pm Subject: SELECT function to select message parts in compute node |
Can you wire up a trace node before and after the compute node that traces ${Envrionment} and paste the output here.
The ${Environment} trace before the compute node is empty, since this is the first ... |
| Topic: SELECT function to select message parts in compute node |
ltopa
Replies: 12
Views: 8279
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Mar 09, 2007 7:52 pm Subject: Re: SELECT function to select message parts in compute node |
the variabe 'instId' is an array as per your code
WHERE P.PARENT_INST_ID = instId
And you are assigning "bind" variable to array rather than a static value ..
I guess your second 'in ... |
| Topic: SELECT function to select message parts in compute node |
ltopa
Replies: 12
Views: 8279
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 08, 2007 5:55 am Subject: SELECT function to select message parts in compute node |
| mgk: the problem with my first code snippet is that I can't seem to get "SELECT P.* ... WHERE P.INST_ID = mylocalVar" to return anything. No errors, it just doesn't select anything (I traced ... |
| Topic: SELECT function to select message parts in compute node |
ltopa
Replies: 12
Views: 8279
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 07, 2007 10:54 pm Subject: SELECT function to select message parts in compute node |
I am trying to use the following select statements in an ESQL file for a compute node:
FOR instId AS Environment.Variables.instId[] DO
SET Environment.Variables.ivPosition[] = &# ... |
