× 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. April 2016

Re: RDi 9.5.0.3 fixpack is now available! (ACS integration explained)

ACS is installed as part of RDi with the 9503 fixpack but we use the
installed ACS by default. By installing ACS yourself, you can use all the
functions of ACS (besides the 2 integrated in RDi) and you can customize
the setup.

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







From: paultherrien <paultherrien@xxxxxxxxxxxxxxxxxx>
To: Jon Paris <jon.paris@xxxxxxxxxxxxxx>, Rational Developer for
IBM i / Websphere Development Studio Client for System i &
iSeries <wdsci-l@xxxxxxxxxxxx>
Date: 04/25/2016 11:36 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>



I imagine that it is just the SQL client portion of iACS that is installed
with
RDi. Just a guess.

On April 25, 2016 at 11:18 AM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:


So are you saying that ACS was installed as part of the fix pack Eric?

I thought I had Java installed in my Windows VM but maybe not.

It is certainly not working - not does it give any error message.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Apr 25, 2016, at 10:49 AM, Eric Simpson <esimpson@xxxxxxxxxx> wrote:

If you run one of the new options which invokes ACS and nothing
appears,
the first thing to check is that you have Java installed on the system.
ACS runs Java and does not use the Java installed by RDi. So, you need
to
have Java 6 or higher on the system. This is a base ACS system
requirement.

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







From: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
To: Wdsci-L <wdsci-l@xxxxxxxxxxxx>
Date: 04/25/2016 10:12 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>



Thanks for the explanation Edmund - but I won’t be taking advantage of
these features.

I’m already forced to use Windows just to run RDi - I’m darned if I’m
going
to install ACS there too when it runs beautifully in native Mac mode.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Apr 25, 2016, at 9:00 AM, Edmund Reinhardt
<edmund.reinhardt@xxxxxxxxxx> wrote:

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 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 <jon.paris@xxxxxxxxxxxxxx>
To: Wdsci-L <wdsci-l@xxxxxxxxxxxx>
Date: 22/04/2016 07:31 PM
Subject: Re: [WDSCI-L] RDi 9.5.0.3 fixpack is now available!
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>



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
www.SystemiDeveloper.com

On Apr 22, 2016, at 11:04 AM, Kurt Anderson
<Kurt.Anderson@xxxxxxxxxxxx>
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
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-86f2-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



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

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

--
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.
Paul Therrien
Andeco Software, LLC
paultherrien@xxxxxxxxxxxxxxxxxx
--
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 ...
Replies:
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.