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

Which tool to use when creating/compiling procedures?

P: n/a
Is it good enough to use IBM DB2 8.2 SQL Development Center to create and
compile procedures?

Or a tool like Embarcadero's Rapid SQL is better? If it is better, would you
know why exactly?

Thank you


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


P: n/a

"serge" <se****@nospam.ehmail.com> wrote in message
news:6I********************@news20.bellglobal.com. ..
Is it good enough to use IBM DB2 8.2 SQL Development Center to create and
compile procedures?
Define "good enough". Obviously, the Development Center is capable of doing
what you want, provided you want procedures written in one of the languages
it supports. If you want a different language, it isn't going to be the
right tool for the job.
Or a tool like Embarcadero's Rapid SQL is better? If it is better, would you know why exactly?

I've never used Embarcadero's tools. You could probably learn about any
advantages they have via their website. You can also get the opinions of
other users by asking questions like this or by looking at product reviews
in database magazines. However, I think it is even better for you to try all
the tools you are considering *yourself*. You might dislike a tool that I
think is great or vice versa. I've tried some tools that were highly
recommended by private individuals or published reviews and not liked them.
The tool has to suit *you* first and foremost.

Rhino
Nov 12 '05 #2

P: n/a
serge wrote:
Is it good enough to use IBM DB2 8.2 SQL Development Center to
create and compile procedures?

Or a tool like Embarcadero's Rapid SQL is better? If it is better,
would you know why exactly?


My vote goes for a tool like vi, emacs, ultraedit, or even notepad. I
don't need a tool to create a table, maintain a file of grants, create
a trigger or a udf. Why would I want one to create stored procedures?
Not sure what it would offer besides headaches in installing,
configuring, and diagnosing it.
ken

Nov 12 '05 #3

P: n/a
I've used both v8 Dev Center (in it's 8.1 status) and RapidSQL. I'll
also throw in Quest v4.5. All will work. The major difference IMO is
the ease of use,speed, and reliability of the UI. RapidSQL and Quest
are full windows clients, so are much richer and more intuitive for
most users already familiar with all the standard windoze bells and
whistles. Both tools have a surprising "depth" into the DB2-specific
syntax.

This does not come cheap however. Don't know the exact pricing of
either tool, but know from experience that it's in excess of $1000 USD.
Dev Ctr has a much more attractive price (free with DBMS!) and MAY give
you access to some features that the 3rd party tools don't (tho that
has not been my experience).

Hope this helps.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.