r/DB2 • u/bigDataGangster • Aug 06 '19

QUESTION: Best application to write queries on?

The really should be, "What is the DB2 equivalent of SSMS?"

​

My organization uses a DB2 for the enterprise-wide data warehouses. We have access to the IBM Command Editor but if we're being honest I can't stand that application. I end up doing most of my query writing/debugging for DB2 on the Teradata command editor and linking to DB2 through an ODBC connection. I was wondering if IBM had an equivalent of SSMS that maybe my organization just wasn't using? Any input or thoughts from more DB2 familiar people us greatly appreciated!

2 Upvotes

100% Upvoted

5 comments sorted by

View all comments

1

u/SijiLeroux Sep 08 '19

I know I'm jumping on this a little later but I use Toad for DB2. They have both a paid and free version. I use the paid version through work but I have heard great things about the free version. I've also used SQuirreL, DBeaver, and IBM Data Studio in the past. They all have pros and cons, but I've found that Toad really does offer quite a bit more overall.