× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



There were some slowness issues with SSMS in SQL 2005, but nowadays I haven't experienced any issues with speed or issues with content assist.

FYI, SSMS is now free, perhaps you can upgrade your's as it is backwards database compatible: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

Be warned, it seems like they update it now quarterly, so you get a lot of features/bug fixes rapidly.

If you want to see the column definitions open up the object explorer and browse to your table. You can then have them open side by side with your query window.

Matt

-----Original Message-----
From: Justin Taylor [mailto:JUSTIN@xxxxxxxxxxxxx]
Sent: Friday, August 11, 2017 11:33 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: STRSQL

SSMS is fully-featured. Although it is incredibly slow, content assist is sporadic and it doesn't give you column definitions for result sets.



-----Original Message-----
From: Matt Olson [mailto:Matt.Olson@xxxxxxxx]
Sent: Friday, August 11, 2017 10:33 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: STRSQL

I'll throw my 2 cents in.

I've tried ACS's new Sql editor, SQL Workbench, SqlDbx, Squirrel, Data Studio, and DBeaver.

As of this point after years of using those various editors, the one that I like the best these days is DBeaver.

I used to use SQL Workbench primarily, and still do for it's Data Pumper feature which syncs data between DB2 systems.

DBeaver is my go-to now because it has full intellisense, foreign key reading, ERD diagram generation, and best of all (due to my several feature requests to the DBeaver developer) it has full field and table comment support so you can see the descriptions on all field names and files. To enable this put in "metadata source" set to 0, and ensure the "read table metadata (unique keys)"

The problem with IBM I DB2 is there is no one SQL Editor that has all features. Having to deal with the DB2 database, versus a MS SQL server database is world's apart in this regard. SQL Management studio in Microsoft's world is so cohesive, fully featured database development tool.

For instance, you can't just use Data Studio, because you can not do query performance analysis because it does not support the SQL EXPLAIN syntax that LUW version of DB2 supports. Instead you must use ACS or IBM I Navigator to get query analysis (only recently did ACS have this ability). It also does not do column meta data reading and it doesn't generate table scripts properly.

You can't use ACS solely because it is missing things like metadata reading (showing field names in query output), activating/deactivating journals (you have to use IBM I Navigator which isn't supported on windows 10 for that), the intellisense/auto-type is extremely rudimentary, there is no concept of hook into version control systems such as Git, there is no schema selector like DBeaver has so you don't have to continually fully qualify your schema statements, instead you have to navigate multiple windows to change default schema, the list goes, on and on.

You can't use DBeaver exclusively because it doesn't generate SQL table scripts because JDBC doesn't support that apparently, and even if it did it wouldn't know about the DB2 specific non-standards like Short column names versus long column names.

In short. DB2 on the I is a bit of a mess.

Matt

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.