RE: STRSQL -- MIDRANGE-L

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

-----Original Message-----
From: Roger Harman [mailto:roger.harman@xxxxxxxxxxx]
Sent: Thursday, August 10, 2017 4:35 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: STRSQL

Open Source. Like SQuirreL.

http://www.sql-workbench.net/

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Danny Hayes
Sent: Thursday, August 10, 2017 1:46 PM
To: Midrange Systems Technical Discussion
Subject: RE: STRSQL

What is SQL Workbench?

Thanks & Regards,
Danny Hayes
IT-Developer
Genuine Parts Company, APG IT

3100 Windy Hill Road
Atlanta, Georgia 30339
mailto:Danny_Hayes@xxxxxxxxx
(904) 502-2969

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Roger Harman
Sent: Thursday, August 10, 2017 4:23 PM
To: Midrange Systems Technical Discussion (midrange-l@xxxxxxxxxxxx) <midrange-l@xxxxxxxxxxxx>
Subject: [EXT] RE: STRSQL

SQL Workbench. Highlight statement, ALT-R. Done. I love that about it.

Also, making SQL lists for "IN()". Highlight list, Alt-L (custom mapped). Done. My boss about fell over when he saw me do that with a column from Excel of about 200 rows.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Thursday, August 10, 2017 12:40 PM
To: Midrange Systems Technical Discussion
Subject: Re: STRSQL

I like to format my queries to make them more readable. Using the prompter undoes any formatting I've already done. For this reason, I tend to keep a field list open in another session, and copy/paste as needed.

Also, as Vern mentioned, the "function" prompter in STRSQL is extremely basic. If you've been around SQL for more than a few months, you probably would never use it.

- Dan

On Thu, Aug 10, 2017 at 3:29 PM, John R. Smith, Jr. < smith5646midrange@xxxxxxxxx> wrote:

I find I still use STRSQL because I never remember the field names and
I can't prompt in ACS.

--
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
--
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

"This e-mail and any attachments, contain Genuine Parts Company confidential information that is proprietary, privileged, and protected by applicable laws. If you have received this message in error and are not the intended recipient, you should not retain, distribute, disclose or use any of this information and you should destroy this e-mail, any attachments or copies therein forthwith. Please notify the sender immediately by e-mail if you have received this e-mail in error."
--
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
--
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