| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database Query from Toolkit |
« View previous topic :: View next topic » |
| Author |
Message
|
| kirankinnu |
 Posted: Wed Apr 30, 2008 7:11 am Post subject: Database Query from Toolkit |
 |
|
Centurion
Joined: 12 Jun 2004
Posts: 128
Location: Chicago, IL
|
Hello folks,
We are able to connect to Oracle database table from ToolKit. We are connecting to a table which has many records and fields. From the Data Perspective is there way to enter the query statements which could show us only limited records in ascending or descending order.
Thank You for the support,
Kiran |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Wed Apr 30, 2008 8:22 am Post subject: Re: Database Query from Toolkit |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi kirankinnu,
I hope you are planning to use esql
| kirankinnu wrote: |
| show us only limited records |
use rownum < n (will retrieve n-1 rows)
| kirankinnu wrote: |
| in ascending or descending order. |
order by
Regards. |
|
| Back to top |
|
|
| kirankinnu |
| Posted: Wed Apr 30, 2008 9:12 am Post subject: |
|
|
Centurion
Joined: 12 Jun 2004
Posts: 128
Location: Chicago, IL
|
Hi,
Nope I am not using ESQL. This is just to look at the sample content from the Data Perspective in the WMB toolkit 6.0. There are other utilities that could be used, but I was wondering if we can do this from Toolkit.
Thank You,
Kiran |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Apr 30, 2008 10:49 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Yes, the Data Perspective includes Query Editors.
_________________
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
|
|
|
|
