Hi Aaron,
You bring up excellent points
I will intersperse my responses
with the prefix ER>
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 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: "Aaron Price" <Aaron.Price@xxxxxxxxx>
To: wdsci-l@xxxxxxxxxxxx
Date: 26/04/2016 08:46 AM
Subject: Re: [WDSCI-L] RDi 9.5.0.3 fixpack is now available! (ACS
integration explained)
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>
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 Id 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!?)
ER> I can tell you that ACS is receiving investment from IBM Rochester and
is the only client that understands the IBM i and is therefore in a
position to do performance analysis as well as running queries.
ER> We have a close relationship with the ACS team and look forward to
deeper integration.
ER> I can tell you with confidence that Data Studio will never be able to
do Visual Explain for IBM i. I would loved to have seen that, but that
ship has sailed and there is just no way.
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 doesnt 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?
ER> This would be a future enhancement, i.e. stripping out the non-SQL
portions of the selection. I would encourage you to open an RFE for this.
As I have given it some thought and would love to have some demonstratable
customer demand to justify the investment.
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"
Im glad that Kurt is excited but I have two problems with this.
1) The option only appears for RPG SQL sources - not COBOL. Havent
checked
for C or CL but Im guessing it will also be missing there. Wouldnt
have
noticed this but Im teaching an Intro to IBM i for mainframe COBOL
folks
this week.
2) The option appears but nothing happens. Im 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.
--
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.
--
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.
NEON - POWERED BY FIGARO
JHC are proud authors of FIGARO.
This message is private and confidential. If you have received this message
in error, please notify us and remove it from your system.
FIGARO and NEON are registered trademarks of JHC Systems Limited. Any
reproduction or use of the words, tricorn logo or their likeness without
express, written consent from JHC Systems is strictly prohibited.
This message has been scanned for all known viruses. However, recipients
are advised to apply their own antivirus detection measures to this message
and any attachments upon receipt.
JHC Systems Ltd is a company registered in England and Wales. Registered
number: 08729370. Registered office:Temple Point, 1 Temple Row, Birmingham,
B2 5LG, England.
--
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
