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


  1.  Home
  2. MIDRANGE-L
  3. August 2017

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

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


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.