| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accessing db content into "Result Set" |
« View previous topic :: View next topic » |
| Author |
Message
|
| K_A |
 Posted: Thu Mar 03, 2005 7:09 am Post subject: Accessing db content into "Result Set" |
 |
|
Apprentice
Joined: 10 Nov 2004
Posts: 32
|
Hi
Probably a very stupid question, but I have not done db access for years.
In a compute node I need to access several rows in an Oracle db.
I have an Order number, and there are several rows in the table matching that order number. Doing a
SET resultset = (SELECT .....)
I guess implies that all occurences are automatically populating my resultset. But, how to declare this resultset? I am looking for a datatyp called "ARRAY" or "VECTOR" but it does not seem to exist.
I do NOT want the struc to be part of the message tree, rather a "temporary message structure", that I eventually can loop thru.
So, how to do it? |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Mar 03, 2005 7:28 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
ESQL doesn't have arrays or vectors. It has scalars and trees.
You can't declare a new tree.
You can, however, pretty freely use the LocalEnvironment and Environment trees as you like.
_________________
I am *not* the model of the modern major general. |
|
| 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
|
|
|
|
