The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.
|
 |
|
Dev Shed Forums
> Databases
> DB2 Development
|
DB2 Resources
Discuss DB2 Resources in the DB2 Development forum on Dev Shed.
DB2 Resources DB2 Development forum discussing administration, DB2 queries, SQL/PL, and other DB2-related topics. Covers the entire DB2 line, including UDB (DB2 for Unix and Linux), midrange (AS/400) and mainframe versions.
|
|
 |
|
|
|
|
|
Dev Shed Forums Sponsor:
|
|
|
May 27th, 2004, 02:57 PM
|
 |
Moderator Emeritus
|
|
Join Date: Feb 2002
Location: Scottsdale, AZ
|
|
|
DB2 Resources
|
May 27th, 2004, 03:52 PM
|
|
Clueless llama
|
|
Join Date: Feb 2001
Location: Lincoln, NE. USA
|
|
__________________
~Nemi
Before posting did you try:
[ Javadocs | Google ]
Last edited by Nemi : May 27th, 2004 at 04:08 PM.
|
May 27th, 2004, 04:06 PM
|
|
Clueless llama
|
|
Join Date: Feb 2001
Location: Lincoln, NE. USA
|
|
|
May 28th, 2004, 04:39 PM
|
 |
Big Endian
|
|
Join Date: May 2001
Location: Fly-over country
|
|
|
May 28th, 2004, 04:49 PM
|
|
Moderator Emeritus
|
|
Join Date: Feb 2002
Location: Scottsdale, AZ
|
|
Quote: | Originally Posted by dcaillouet |
Is Quest's DB2 tool any better than TOAD (which, IMHO, has one of the worst UI of any RDBMS tool I've ever used...) - or, is it basically a TOAD port for DB2? Just curious...
|
May 28th, 2004, 08:37 PM
|
 |
/(bb|[^b]{2})/
|
|
Join Date: Nov 2001
Location: Somewhere in the great unknown
|
|
|
Just curious, but why even use TOAD or Quest's DB2 tool over IBM's Administration interface?
|
June 3rd, 2004, 01:07 PM
|
|
Moderator Emeritus
|
|
Join Date: Feb 2002
Location: Scottsdale, AZ
|
|
|
more resources
The DB2 Book Suggestions thread also contains valuable links to books, various informational sites, etc.
|
June 3rd, 2004, 10:08 PM
|
|
Contributing User
|
|
Join Date: Jun 2003
Location: Waco, Texas
|
|
Quote: | Originally Posted by Onslaught Just curious, but why even use TOAD or Quest's DB2 tool over IBM's Administration interface? |
Well, I have used Platinum, BMC, and Quest as an interface to the DB. All were superior to what is now DB2's control center, simply easier to use, period. Quest is our latest tool, and seems very satisfactory (well it lacks some things re:
getting to functions and stored procedures...) Quest does seem 10 times faster than the DB2 admin tool - perhaps it is because the DB2 tool is Java/JDBC - based? Many times it has caused a reboot - memory leakage?
For just running a bunch of queries against the database
on the fly - the free version of WinSQL is my tool of choice.
Very light footprint and quick.
fv
__________________
...because that is the way we have always done it. We've been doing it like that for 80 Years! (How do we change that mindset?)
|
June 4th, 2004, 08:29 AM
|
|
/(bb|[^b]{2})/
|
|
Join Date: Nov 2001
Location: Somewhere in the great unknown
|
|
|
Don't get me wrong, I'm not downing any custom tool out there. I personally have one that I built on my own to interact with my database, but then my reasoning was because I deal with more than just DB2 and this application allows me to interact with DB2, MSSQL, and MySQL at the same time.
I will agree that it isn't as fast as a C/C++ or other compiled appliction because it is done in java. Though, I will have to say that you can access store procedures and functions via the control center.
|
June 4th, 2004, 08:41 AM
|
|
Contributing User
|
|
Join Date: Jun 2003
Location: Waco, Texas
|
|
|
The control center has been quite usefull for building/debugging PSQL stored procs - the source-level deugger is a very valuable tool. With version 8 (UDB/NT)
it has changed totally - now called the Development Center with a totally different interface that I have not explored much. Also it seems integrated into Visual Studio.NET. Next release (code-named Stinger) we will be able to write stored procs in VB.NET...interesting!
fv
|
June 4th, 2004, 08:49 AM
|
|
/(bb|[^b]{2})/
|
|
Join Date: Nov 2001
Location: Somewhere in the great unknown
|
|
|
The version 7.2 also has a plugin for VS6. I have it installed, but I have not used it though.
|
June 4th, 2004, 09:23 AM
|
|
Contributing User
|
|
Join Date: Jun 2003
Location: Waco, Texas
|
|
I do recall reading somewhere that you could build what they were calling OLE stored procs with VB6, but info was so scarce that I did not pursue. There is a good book on procedural SQL langage for DB2 here: http://www.phptr.com/
just search for DB2 and you will find it.
fv
|
July 21st, 2004, 11:19 AM
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
db2 resources
publib.boulder.ibm.com/infocenter/db2help/index.jsp
Last edited by Nemi : November 24th, 2006 at 11:06 AM.
Reason: made url visible
|
November 24th, 2006, 08:50 AM
|
|
Registered User
|
|
Join Date: Nov 2006
Posts: 1
Time spent in forums: 10 m 31 sec
Reputation Power: 0
|
|
Reporting for DB2 Express C
Synaptris has released a free reporting software for DB2 Express C users, visit www. synaptris. com/go/expressc for more details and for downloading the software.
|
December 17th, 2008, 04:38 AM
|
|
Registered User
|
|
Join Date: Dec 2008
Posts: 1
Time spent in forums: 1 h 16 m 56 sec
Reputation Power: 0
|
|
I prefer DB2 Maestro, the perfect substitute for TOAD and in some ways also much better product (much cheaper, suberb design and interface, and the support is fast and easy.). I have just pumped an MS SQL database into a DB2 database. All the data including the indexes and foreign keys with just a few clicks. 
|
Developer Shed Advertisers and Affiliates
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Rate This Thread |
 Linear Mode
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
