MQSeries.net :: View topic - Intriguing and Perplexing

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Intriguing and Perplexing - Muliple database selects

Intriguing and Perplexing - Muliple database selects

« View previous topic :: View next topic »

Author

Message

Posted: Tue Apr 26, 2005 4:27 am Post subject: Intriguing and Perplexing - Muliple database selects

Newbie

Joined: 26 Apr 2005
Posts: 3

Hey all been around for a while and found this site to be the place to go to for answers

Here is the scenario

A single database holds X records

I need regularly to select everyitem in the database based on a partiular column

for example

name address Telephone
a b 1
c d 2
e f 3
g h 4
i j 5
k l 6

so for any entry on telephone not equal to (<>) 0 select all the values for columns name, address, telephone

I then have to cretae a message based on each row

<message>
<name>a</name>
<address>b</address>
<telephone>1</telephone>
</message>

so for every ROW i have to PROPAGATE a message based on that rows contents.

OK here the catch

I can build a message and PROPAGATE it for a single lookup and that works fine

I cannot get round the every item portion

any help or ideas would be appreciated

jefflowrey

Posted: Tue Apr 26, 2005 4:43 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Have you considered using a loop?
_________________
I am *not* the model of the modern major general.

Posted: Tue Apr 26, 2005 4:44 am Post subject:

Newbie

Joined: 26 Apr 2005
Posts: 3

apologies have sorted the extract using RESULTSET which are automatically populated when a lookup is made

This has brought about another problem though

How do I incrment the Resultset Value used in the construction of the output message to match the value in the select?

eg

SET NAME = TRIM(TRAILING ' ' FROM Environment.RESULTSET.[1].NAME)

how do i up the [1]

jefflowrey

Posted: Tue Apr 26, 2005 4:47 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

K9 wrote:

how do i up the [1]

Have you considered using a loop?
_________________
I am *not* the model of the modern major general.

Posted: Tue Apr 26, 2005 5:09 am Post subject:

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.

Quote:

How do I incrment the Resultset Value used in the construction of the output message to match the value in the select?

By introducing a variable that you can increment:

Code:

DECLARE resultsetIndex INTEGER 1;
WHILE ........
SET NAME = TRIM(TRAILING ' ' FROM Environment.RESULTSET.[resultsetIndex].NAME);
SET resultsetIndex = resultsetIndex + 1;
Do other stuff.....
END WHILE;

You might want to also look at the FOR statement.

Posted: Tue Apr 26, 2005 7:44 am Post subject: ****SOLVED****Intriguing and Perplexing - Muliple database

Newbie

Joined: 26 Apr 2005
Posts: 3

Many thanks guys

Gothe lookup and resultsets working a peach and is generating a message via PROPAGATE

JT had to modify your code a little and ended up using the FOR statement as you recomended.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Intriguing and Perplexing - Muliple database selects

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