| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ESQL code which can behave like a recordset? |
« View previous topic :: View next topic » |
| Author |
Message
|
| ryzor |
 Posted: Mon Jan 19, 2004 4:58 am Post subject: ESQL code which can behave like a recordset? |
 |
|
Apprentice
Joined: 31 Dec 2001
Posts: 42
|
Hi Guys
Is there a code/ or utility which can behave like a recordset data container for group of records which are pulled from a SQL database, so this returned records can be queried and manipulated locally from the recordset - thus eliminated the need for multiple queries to the database for fields which are in the same table?
any help will be highly appreciated.
thanx, ryzor. |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Jan 22, 2004 11:51 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Yes, you can do this using ESQL. Please refer to ESQL Reference Manual, they have one chapter on SELECT. You can first retrieve the resultset into Environment tree, and then perform query on Environment tree itself.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
