RE: What do you use "IBM Data Studio" for?

Nice !!

Regards,


Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com

------------------------------

message: 6
date: Fri, 2 Dec 2016 20:11:30 +0000
from: Matt Olson <Matt.Olson@xxxxxxxx>
subject: RE: What do you use "IBM Data Studio" for?

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