Regarding the new �Launch Run SQL Scripts� functionality:
1. Visual explain is not available in the new version of Run SQL
and this was the only reason I would use Run SQL scripts normally
(Because visual explain is also not available in RDi which would be my
preference). The ability to run SQL over the database is already baked
into RDi (regardless of if Data Studio is installed) and RDi provides
better data export functionality than Run SQL scripts (to excel, csv
etc). Therefore at present I�d much rather have the SQL inserted into a
new SQL script (or SQL scratchpad for none data studio users) than use
the Run SQL scripts functionality. Can anyone advise why Run SQL scripts
has been chosen in favour of running the SQL via RDi? i.e. what it does
better than RDi (and should I start using it more!?)
Also some usability questions:
2. Our source control system uses the comment characters in
positions 1-5 of source lines to store version numbers, and these get
inserted into the RunSQL script unless doing a rectangular select. This
would also affect anyone using the �Add signature to changes lines�
option in RDi. I realise that IBM are moving toward �fully free� which
removes these comment characters but at the moment having to change to
rectangular select to use this is a minor annoyance. Could the option to
ignore the first 5 characters of a source line (and possibly the
comments at the end of the lines) be offered when using this?
3. Run SQL Scripts doesn�t ignore the EXEC SQL statement, so the
fact that that is copied and requires removal is another minor
annoyance. Since this statement is not valid SQL, can it be removed when
copying to Run SQL scripts?
Thanks
Aaron
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> [mailto:WDSCI-L
<wdsci-l-bounces@xxxxxxxxxxxx>] On Behalf Of Eric Simpson
<esimpson@xxxxxxxxxx>
Sent: 25 April 2016 16:02
To: Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries <wdsci-l@xxxxxxxxxxxx> <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] RDi 9.5.0.3 fixpack is now available! (ACS
integration explained)
http://www.ibm.com/support/knowledgecenter/SSAE4W_9.5.0/com.ibm.etools.
iseries.rse.doc/topics/acs_ovr.html
has information about the ACS integration in RDi.
Thanks,
Eric
Eric Simpson
Rational Developer for i - Rational Developer for
AIX and Linux - Rational Developer for Power
IBM Software Group - Canada Lab
Phone: 905-413-3226 (T/L: 313-3226)
esimpson@xxxxxxxxxx <mailto:esimpson@xxxxxxxxxx>
From: Edmund Reinhardt/Toronto/IBM@IBMCA
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries
Date: 04/25/2016 09:05 AM
Subject: Re: [WDSCI-L] RDi 9.5.0.3 fixpack is now available! (ACS
integration explained)
Sent by: "WDSCI-L"
Jon,
RUN SQL is completely independent of Data Studio. You don't even have
to
have Data Studio installed. Instead it is using the Access Client
Solutions support which has recently been added and is IBM i specific.
If
you already have ACS installed we will use the existing install,
otherwise
we will launch from the copy shipped with RDi. But you can always start
ACS yourself and run the function from there.
The savings with ILE RPG is that we will take your selection in the
editor
and prepopulate the Run SQL Statement page in ACS with that. So if you
select you SELECT statement in RDi, and select "Launch Run SQL Scripts"
from the Source menu, we will bring up ACS, connect to the same IBM i
your
source if from, and populate the page in ACS. All you have to do is hit
the Run button.
So this is a much tighter integration story then we have ever had
before.
We also integrated with ACS for spooled file support. If you right
click
on the 'Spooled Files' subsystem and select 'Launch Printer Output', we
again bring up ACS showing the output queue on the current system. You
can
filter which queues and users you want to show on the Edit->Filter
dialog,
you can click on any column to sort, you have lots of download options.
Go ahead and play.
Regards,
Edmund (E.H.)
Reinhardt
Technical Architect for Rational Developer for i
Phone: 1-905-413-3125 | Home: IBM
1-905-854-6195
E-mail: edmund.reinhardt@xxxxxxxxxx
<mailto:edmund.reinhardt@xxxxxxxxxx> 8200 Warden Ave
RDi Community: ibm.biz/rdi_hub Markham, ON L6G 1C7
Find me on: LinkedIn: Canada
http://ca.linkedin.com/in/edmundreinhardt/
From: Jon Paris
To: Wdsci-L
Date: 22/04/2016 07:31 PM
Subject: Re: [WDSCI-L] RDi 9.5.0.3 fixpack is now available!
Sent by: "WDSCI-L"
I�m glad that Kurt is excited � but I have two problems with this.
1) The option only appears for RPG SQL sources - not COBOL. Haven�t
checked
for C or CL but I�m guessing it will also be missing there. Wouldn�t
have
noticed this but I�m teaching an Intro to IBM i for mainframe COBOL
folks
this week.
2) The option appears but nothing happens. I�m guessing that is because
I
have not plugged Studio into RDi - I run it free-standing. Can the
IBMers
here please confirm this? I would have expected the option to only
appear
if the feature was enabled in the product but ...
Jon Paris
www.partner400.com <
http://www.partner400.com>
www.SystemiDeveloper.com <
http://www.SystemiDeveloper.com>
On Apr 22, 2016, at 11:04 AM, Kurt Anderson
wrote:
Excellent news. Very pumped about this fix pack.
Surprised to see Run SQL Scripts available from within RDi. That's
excellent! Except I don't understand why this option is only available
when you have a SQLRPGLE source selected. I understand wanting access
to
it when working in SQL RPG, but I find I want access to SQL all the
time,
even if I'm working on native I/O RPG (or even CL - honestly anytime I
want
to look at data, which is any point during the day).
With that said, I think access to Run SQL Scripts via RDi is
absolutely
amazing. Previously I only ever used it very rarely (pretty much only
if I
was testing a stored procedure) because getting to it via Navigator was
horribly annoying. I'm confident that I'll be using it quite a bit now.
Maybe I'll finally stop using STRSQL?
Kurt Anderson
Lead iSeries Developer - Application Development, Service Delivery
Platform
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Eric
Simpson
Sent: Thursday, April 21, 2016 4:33 PM
To: wdsci-l@xxxxxxxxxxxx <mailto:wdsci-l@xxxxxxxxxxxx>
Subject: [WDSCI-L] RDi 9.5.0.3 fixpack is now available!
For details, see the blog post at
https://www.ibm.com/developerworks/community/blogs/49773f8f-a20d-4816-8
6f2-44a2d862dbc1?lang=en
Thanks,
Eric
Eric Simpson
Rational Developer for i - Rational Developer for
AIX and Linux - Rational Developer for Power
IBM Software Group - Canada Lab
Phone: 905-413-3226 (T/L: 313-3226)
esimpson@xxxxxxxxxx <mailto:esimpson@xxxxxxxxxx>
--
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 <mailto: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
<mailto:WDSCI-L-request@xxxxxxxxxxxx>
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
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
<mailto: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
<mailto:WDSCI-L-request@xxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.
midrange.com
