Hi Mike
1) You have the ability to run any CL in RDi in the Commands view. That
has been there from day 1. The only limit is that if it is an interactive
command you have to run STRRSESVR in an emulator first to provide a target
5250 for the command.
2) You can select whatever SQL you want to run from in the SQL script
editor and it will only run that SQL. Just tried it now.
3) Visual Explain is not integrated yet. I am aware of the requirement
(and you are free to vote on it). I have a plan, but not the resources
yet. It will take some technical underpinnings.
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=11086
I believe you can run SQL against the system catalogs, they are just SQL
tables/views.
Integration with MS Access, I am sorry, that is not on my radar and I doubt
IBM will invest in this. I will keep it in mind when I do the integration
with RDi, but it will take some custom plugins to do.
Regards,
Edmund (E.H.) Reinhardt
Technical Architect for Rational Developer for i
Phone: 1-905-413-3125 | Home: 1-905-854-6195
E-mail: edmund.reinhardt@xxxxxxxxxx
RDi YouTube: 8200 Warden Ave
www.youtube.com/user/IBMRational#g/c/62DF24D5BCD43501 Markham, ON L6G 1C7
Find me on: Canada
From: "Jones, Mike" <mike.jones@xxxxxxxxxxxxxxx>
To: "wdsci-l@xxxxxxxxxxxx" <wdsci-l@xxxxxxxxxxxx>
Date: 03/11/2014 02:02 PM
Subject: Re: [WDSCI-L] WDSCI-L Digest, Vol 12, Issue 533
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>
Features lacking in Data Studio (to the best of my knowledge), where the
features I miss the most are listed first, that would be nice to see in
RDi:
1) Navigator like ability to run a CL command by preceding it with a "CL:"
in the run script window. I want that to easily set a library list, or to
run CHGQRYA, CHGJOB, CHGPFCST, CHGPFTRG, ENDJRNPF, STRJRNPF, and
occasionally a handful of other CL commands. I already have SQL table and
scalar user defined functions that will execute CL commands as parameters,
so I can work around that by typing more verbose commands. However, the CL:
Navigator ability returns command execution result messages in some cases
that come in handy at times, and that behavior might be difficult for me to
mimic from SQL UDTF's inside RDi (i.e. message feedback area including CL
execution messages). I could fairly easily return those CL command
execution messages in a result set window from a UDTF that executes CL
using the JOBLOG_INFO UDTF I suppose, but if this functionality were
built-in it would likely perform faster than calling JOBLOG_INFO.
2) Double Click option to run a single SQL statement inside a longer SQL
script (like Navigator supports). Perhaps Data Studio supports this and
I've not figured out where to apply said setting.
3) Visual Explain for System i (I use Visual Explain in Navigator
occasionally, in particular for the Index Advisor).
This next feature may be a bit much to wish for, but I'd like the ability
to call the SQL Script feature in RDi from an external application, and to
be able to pass the modified SQL script back to the caller after making
changes and performing testing. This next paragraph, one of my current use
cases, explains why this would be beneficial to me, but I'm not your bread
and butter RDi user since I use SQL functions to run SQL scripts (i.e. I'm
not using RPG to run SQL):
I use a Microsoft Access application to maintain database migration SQL
Scripts in a System i SQL script host-side database, which works great,
except for the fairly primitive Textbox control editor built into Access
used to maintain the SQL script column in the script database. When I have
a large, complex script that requires extensive editing, I copy and paste
it over into the RDi / LPEX editor, make my changes there, copy/paste it
into Navigator to test, and copy/paste it back into Access to save the
final result to the host. My ideal world is where I had an Access button
"Edit in Data Studio or RDi", where I could call the external SQL Script
feature and have the SQL script pop up in a Eclipse tab to perform editing
and testing, and when I was done, hit a save button where the results were
transparently sent back to Access. My gut tells me that is probably
possible but it would likely take me a lot of time to write or find a
custom plug-in to handle the interprocess co
mmunication. My ideal world for an SQL feature includes LPEX caliber
editing, coupled with configurable SQL formatting, with advanced SQL build
assist, with robust SQL script execution including some of the Navigator
features that aren't currently in Data Studio (mainly those listed above
plus Navigator like buttons Run All, Run from Selected, Run Selected), with
Visual Explain for i, coupled with the ability to call said function from
an external application with an SQL script as a parameter, and the ability
to send the modified SQL script back to the calling application.
I also spend a fair amount of time working with System Catalog metadata so
I need fast, preferably integrated access to that data inside Data Studio
or RDi, but I've not yet taken the time to see if that is possible in Data
Studio. Some of the System i System Catalog objects are fast and some have
performance issues, so I suspect "fast" access to all of them will require
significant host side changes. If RDi had a feature or plug-in designed for
efficient slicing and dicing of a System i System Catalog I'd likely gain
productivity from its use as long as performance was good.
Mike
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of
wdsci-l-request@xxxxxxxxxxxx
Sent: Thursday, October 30, 2014 11:38 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: WDSCI-L Digest, Vol 12, Issue 533
Send WDSCI-L mailing list submissions to
wdsci-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/wdsci-l
or, via email, send a message with subject or body 'help' to
wdsci-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
wdsci-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific than
"Re: Contents of WDSCI-L digest..."
Please consider the environment before printing this email.
The information contained in this e-mail and its attachments are
confidential to
the intended recipient and may be legally privileged or otherwise protected
from
disclosure. If you have received this message in error,you must not print
this
email or its attachments. Please notify the sender immediately and delete
the
message and any attachments from your computer. The unauthorized use,
disclosure,
copying or alteration of this message is forbidden. Emails are not secure
and may
contain viruses. Vertex accepts no responsibility for viruses; it is your
responsibility to scan or otherwise check this email and any attachments.
--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/wdsci-l.
midrange.com
