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

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.