473,543 Members | 1,826 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Which tool to use when creating/compiling procedures?

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
3 1378

"serge" <se****@nospam. ehmail.com> wrote in message
news:6I******** ************@ne ws20.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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4919
by: Joonas Paalasmaa | last post by:
Hi, When compiling Sketch's streamfilter C extension the errors below are raised during linking. What could cause the errors? (Python 2.3, MinGw 1.1 with GCC 2.95.3-6, Windows 98) Here are the occurrences of FilterType that may be relevant: ------- C:\sketch\sketch-0.7.12\Filter\filterobj.c: 949: PyTypeObject FilterType = {
9
2065
by: TPJ | last post by:
First I have to admit that my English isn't good enough. I'm still studying and sometimes I just can't express what I want to express. A few weeks ago I've written 'Python Builder' - a bash script that allows anyone to download, compile (with flags given by user) and install Python and some external modules (e.g. wxPython, PyGTK,...
17
6109
by: John Bentley | last post by:
John Bentley: INTRO The phrase "decimal number" within a programming context is ambiguous. It could refer to the decimal datatype or the related but separate concept of a generic decimal number. "Decimal Number" sometimes serves to distinguish Base 10 numbers, eg "15", from Base 2 numbers, Eg "1111". At other times "Decimal Number" serves to...
13
2120
by: EggsAckley | last post by:
Hi: I have a file that I have been told is a SQL Server backup from a server somewhere. The file is about 200MB in size I am trying to create the database on my local server using RESTORE. I created the backup device, associated it with a backup name etc., copied the file into the backup dir. When I run the RESTORE command, Query...
0
3742
by: PASQUALE | last post by:
Hi, I am new to DB2 on AS/400. Actually I use the 'Run SQL Scripts' - tool in iSeries Navigator to access the database by SQL. The question is: Is there an alternative (or maybe better) tool for SQL on DB2? When I worked with MsSQL there was a tool called 'Query Analyzer' wchich was very comfortable (fixed-width font, syntax coloring, much...
34
10767
by: Jeff | last post by:
For years I have been using VBA extensively for updating data to tables after processing. By this I mean if I had to do some intensive processing that resulted in data in temp tables, I would have VBA code that wrote the results of that away to the db, either creating new records or updating existing records, whichever was relevant. This may...
15
3167
by: Rob Meade | last post by:
Hi all, I have a databse which I'm pulling the data from for my ASP page. I have 4 tables, Course, Feature, Objective, and PreRequisite. The last three all contain a course product code and a text column - the course product code links the row(s) to the Course table. So, I might have 1 entry in Course, but perhaps 3 in Feature, 5 in...
1
1490
by: fireball | last post by:
is there any documentation generating tool for SqlServer? (like pldoc for Oracle)?
37
2365
by: C_guy | last post by:
Does anyone know of a (hopefully free) tool that can traverse a project and determine which "#include"s are not needed or needed in every .C file? This would be helpful in removing header inclusions that are redundant and/or unnecessary. Thanks!
0
7411
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7594
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7746
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7354
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7693
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5282
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3394
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
978
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
643
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.