By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

DB2 SQL Developer Tool

P: n/a
Hi,

I am switching from an Oracle enviornment to DB2. We are currently
using the TOAD product with the Oracle DB to write queries, stored
procedures, view tables, view data, etc. Can anyone suggest a similar
tool to use with DB2? Does DB2 come with a good product (Oracle does
not)?

Thanks.

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Just FYI:

Toad for DB2 is currently in Beta. Product launch is expected on Oct
25th.

More info at:

http://www.toadsoft.com/toaddb2/

-- Arutr Wronski

Nov 12 '05 #2

P: n/a
dz*******@gmail.com wrote:
Hi,

I am switching from an Oracle enviornment to DB2. We are currently
using the TOAD product with the Oracle DB to write queries, stored
procedures, view tables, view data, etc. Can anyone suggest a similar
tool to use with DB2? Does DB2 come with a good product (Oracle does
not)?

Thanks.

I find AquaDataStudio quite easy to use and relatively inexpensive with
responsive tech support for both problems and enhancements. Read more
about it and download it from:

http://www.aquafold.com/
Nov 12 '05 #3

P: n/a
DB2's control center is ok, and it sounds like Toad will be available
soon.

Meanwhile, AQT is fast, inexpensive and competitive::
http://www.querytool.com/features.html
Buck

Nov 12 '05 #4

P: n/a
<dz*******@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Hi,

I am switching from an Oracle enviornment to DB2. We are currently
using the TOAD product with the Oracle DB to write queries, stored
procedures, view tables, view data, etc. Can anyone suggest a similar
tool to use with DB2? Does DB2 come with a good product (Oracle does
not)?

Thanks.


There are a lot of 3rd party tools for DB2, but not all assist with writing
stored procedures, etc. Maybe Toad for DB2 is one of those that does.

The DB2 Development Client (which is free) is available with those features
you requested. The Development Client is basically the Administrative Client
plus the facility to help write stored procedures. Even for DBAs that use
3rd party tools, almost everyone has one of the free DB2 clients installed
on their machines.
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.