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
midrange.com
