| Author |
Message |
 Topic: SELECT using IN (?,?,...) with variable number of parameters |
nr525
Replies: 10
Views: 8177
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Dec 17, 2004 5:00 am Subject: SELECT using IN (?,?,...) with variable number of parameters |
Thanks for your time, it does work with just a single list so that will do just fine for now.
Is there any particular reason it won't handle the combination of list and comma separated scalar param ... |
| Topic: SELECT using IN (?,?,...) with variable number of parameters |
nr525
Replies: 10
Views: 8177
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 16, 2004 7:37 am Subject: SELECT using IN (?,?,...) with variable number of parameters |
Well yes thats certainly whats happening but interestingly the documentation for passthru implies the opposite;
-----
SET OutputRoot.XML.Result.Data[]
= PASSTHRU('SELECT AccountNum FROM user2.A ... |
| Topic: SELECT using IN (?,?,...) with variable number of parameters |
nr525
Replies: 10
Views: 8177
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 16, 2004 5:06 am Subject: SELECT using IN (?,?,...) with variable number of parameters |
Thanks for your time on this one.
I cut down the code to this test which still fails in the same way.
-------------------------------------------------------------------------------------
DECLA ... |
| Topic: SELECT using IN (?,?,...) with variable number of parameters |
nr525
Replies: 10
Views: 8177
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 16, 2004 1:41 am Subject: SELECT using IN (?,?,...) with variable number of parameters |
Thanks for the response and yes your right the number of question marks should match the number of elements in the environment tree.
Problem is that the number of question marks is built based on ... |
| Topic: SELECT using IN (?,?,...) with variable number of parameters |
nr525
Replies: 10
Views: 8177
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 15, 2004 9:28 am Subject: SELECT using IN (?,?,...) with variable number of parameters |
Hi,
I'm trying to select a number of rows from the database dependant on message content using WHERE somecolumn IN ('','',''....) . The number of values to be matched varies per message. So I have ... |
| Topic: WMQ 5.3 on Solaris 6 |
nr525
Replies: 0
Views: 2009
|
Forum: General IBM MQ Support Posted: Thu Apr 24, 2003 11:50 pm Subject: WMQ 5.3 on Solaris 6 |
Hi,
Whilst I know WMQ 5.3 is not formally supported on Solaris 6 and infact Solaris 6 is close to entering vintage II of the Sun life-cycle, I would like to know if anyone has had success running ... |
| Topic: eclipse IDE & mq error messages |
nr525
Replies: 2
Views: 2156
|
Forum: IBM MQ Java / JMS Posted: Wed Feb 05, 2003 5:46 am Subject: eclipse IDE & mq error messages |
Thanks I found the file in the support pack installation and added it to the classpath file of the project.
Thanks again,
AJ |
| Topic: eclipse IDE & mq error messages |
nr525
Replies: 2
Views: 2156
|
Forum: IBM MQ Java / JMS Posted: Wed Feb 05, 2003 4:13 am Subject: eclipse IDE & mq error messages |
Folks,
I'm currently using the Eclipse IDE and I have got an mq server program running in the IDE (its waiting on messages, doing a variety of processing and putting a reply)
To debug all this I ... |
| Topic: How I can stop/start a message flow from a command line |
nr525
Replies: 6
Views: 4893
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 10, 2002 4:30 am Subject: How I can stop/start a message flow from a command line |
| I read with interest the suggestion to inhibit gets on the input queue to a message flow. This is something I have been trying to do but currently I have had no joy. I will certainly try to source th ... |
| Topic: XML parse error bip5004 |
nr525
Replies: 3
Views: 2896
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 13, 2002 11:31 pm Subject: XML parse error bip5004 |
Thanks for your response
Yes J is declared and yes you can the brackets or not bother.
Like I said I'm not always having problems with this, but that maybe because there is no data in these fiel ... |
| Topic: XML parse error bip5004 |
nr525
Replies: 3
Views: 2896
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 13, 2002 6:10 am Subject: XML parse error bip5004 |
Hi,
I'm processing quite a large number of records through the broker whereby I transform the message from an MRM defined fixed length message to XML. This seems to work just fine for all but two o ... |
| Topic: basic flow quections |
nr525
Replies: 1
Views: 2384
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 05, 2002 3:32 am Subject: basic flow quections |
What error are you getting ? Bip msg num, and detail if possible
To get some sort of trace your going to need to wire this up in a different way for example than you would under normal processing. ... |
| Topic: funny hex like chars when reading xml msgs from a queue |
nr525
Replies: 4
Views: 3559
|
Forum: IBM MQ Java / JMS Posted: Tue May 28, 2002 7:03 am Subject: funny hex like chars when reading xml msgs from a queue |
Okay I figured this out... A simple error really but It didn't jump out at me unfortunately..Here we go...
When I put the message to the queue I was using writeUTF,
but
When I used a different J ... |
| Topic: funny hex like chars when reading xml msgs from a queue |
nr525
Replies: 4
Views: 3559
|
Forum: IBM MQ Java / JMS Posted: Mon May 27, 2002 2:34 am Subject: funny hex like chars when reading xml msgs from a queue |
I can see the problem when getting messages put onto the queue using a test program to put the message.
Current levels:
OS: Solaris 2.7
Java: 1.1.3 or/ 1.3.1_02
MQSeries: 5.2.1
I can put an x ... |
| Topic: funny hex like chars when reading xml msgs from a queue |
nr525
Replies: 4
Views: 3559
|
Forum: IBM MQ Java / JMS Posted: Fri May 24, 2002 6:20 am Subject: funny hex like chars when reading xml msgs from a queue |
HI folks, I'm having a problem reading an xml message from a queue using Java.
Basically when I read the message off the queue and write it as a string out to a file or the screen I see some funny ... |
