× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. WDSCI-L
  3. May 2016

Re: Why ACS?

Visual explain was always on the target list but If I understand it
correctly difficult to do because of the APIs used to render the display.
While I'm quite anxious to get it (have been since the new *ADMIN server
came out without it and Management Central, most of which has been
completed) I'm of the opinion I'd rather have it right and slow than broken
and fast.

--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Edmund
Reinhardt
Sent: Wednesday, April 27, 2016 9:39 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries
Subject: Re: [WDSCI-L] Why ACS?


I have received permission to let you know that Visual Explain is coming
soon to ACS!
So hopefully you see the advantages that ACS will give us.



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: Edmund Reinhardt/Toronto/IBM@IBMCA
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Date: 27/04/2016 09:01 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>




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
ER> 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
ER> 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.

--
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.


--
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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.