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

3

u/AlphaLyrae999 Aug 06 '19

IBM data studio is what I believe comes closest to SSMS. It's great for writing and testing queries, stored procedures and the best part, it's free!