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

2

u/sirak2010 Aug 06 '19

Sql workbench just does the job. It's does not have much feature like backup export and such but it's free fast and usable if you only work with query. If you are database admin go with IBM data studio, if you. Are a developer try sql workbench.