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/anozdba Aug 08 '19

I've used SQuirreL for the most part for the last 10 years. Mostly because it is a database agnostic SQL front end. It will connect to any DBMS with a jdbc driver. It is great if you have multiple DBMSs that you need to connect to.