SQL Workbench is also my goto editor for IBM i database querying. Especially now that the developer added the cool function to display the column text descriptions within the query result grid so you can make sense of the short cryptically named columns that are often found in IBM i DB2 databases due to the 10 character legacy limit for a column name.
If you watch folks who still use WRKQRY run SQL statements and the number of keystrokes they make compared to those who use a tool like SQL Workbench, the amount of typing is dramatically less when using SQL Workbench. Especially when you are trying to do a bunch of variations of a query and go back and forth between them. In SQL Workbench you just highlight the statement you want and run, then copy that statement and paste and revise it a bit and run that one. No flipping through dozens of menus and screens.
-----Original Message-----
From: Roger Harman [mailto:roger.harman@xxxxxxxxxxx]
Sent: Friday, December 2, 2016 12:45 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: What do you use "IBM Data Studio" for?
I guess I need to try and remember Data Studio. I usually use SQL Workbench/J (mostly for the save as XLS* formats), although I do fall back to STRSQL for a quick inquiry.
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
Sent: Friday, December 2, 2016 5:12 AM
To: Midrange Systems Technical Discussion
Subject: Re: What do you use "IBM Data Studio" for?
I have found it to be as you say - we already have the Data perspective in RDi. Data Studio has some knowledge of IBM i objects for database, but I believe only in an SQL kind of way.
That's probably good enough for some stuff. I just never found it gave me what I was used to in Navigator.
Some people use Squirrel, others use QuantumDB - both are SQLish (I don't mean SQL Server, I mean the technology that is SQL). :)
The database component of the thick Navigator was really useful, although it's not where I ever spent major development effort time.
I'm finding the ability to test SQL statements from RDi using the statement runner is really useful - that will probably become my most-used way of working, even more than STRSQL!!
HTH
Vern
On 12/2/2016 7:00 AM, Justin Taylor wrote:
I hear people talk about IBM Data Studio, so I finally installed it. I've played with it for a while, and I confess that I don't get it. It seems to be more trouble than it's worth, so I'm wondering why other people use it. Why use Data Studio instead of something else like iNav?
Thanks
--
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
MIDRANGE-L Info Page
lists.midrange.com
To unsubscribe from MIDRANGE-L, get a password reminder, or change your subscription options enter your subscription email address:
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
midrange.com -- MIDRANGE-L mailing list archive
archive.midrange.com
midrange.com MIDRANGE-L mailing list archive
Please contact support@xxxxxxxxxxxx for any subscription related questions.
midrange.com
