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



I believe you are correct, Vern. The two ACS features are bundled with RDi.

I would suggest - for the time being, anyway - there's more flexibility to be had by installing ACS separately. (For example: Run SQL Scripts at any time, not just while editing an SQLRPGLE source member.)

Brian.

-----Original Message----- From: Vernon Hamberg
Sent: Sunday, August 14, 2016 2:19 PM
To: Rational Developer for IBM i / Websphere Development Studio Client forSystem i & iSeries
Subject: Re: [WDSCI-L] Launch Run SQL Scripts

Hi Brian

I was told at a meeting with IBM that ACS is bundled with RDi as of
version 9.5 - certainly, at least, the Run SQL Scripts feature - this
was to ensure that the feature is available.

Printed output in RDi is also delivered using that feature of ACS.

I have tried the Run SQL Scripts feature - nice to select a statement,
then take a menu option and be able to analyze it.

I've not tried to change the system it's connected to in Run SQL Scripts
- it's in the plugin for the Windows client, I would assume it's in this
one. But maybe it's tied to the connection you come from.

We're both making assumptions - I'm not at a connection to our system,
nor on my work laptop, so can't verify any of this. Hope someone does.

Might be an opportunity for a COMMON requirement or RFE.

Vern

On 8/14/2016 4:22 AM, Brian Parkins wrote:
Stuart, at this point in time you will get better results if you download the IBM i Access Client Solutions (ACS) tool and install separately. (It is effectively free and the latest version 1.1.6.0 has some _very_ nice enhancements - including Visual Explain.)

Within ACS, use System Configuration to define a (single) connection to each server. (Shame we still cannot define multiple system connections as per RDi.) When you invoke the Launch Run SQL Scripts function within RDi it should pick up all the available ACS connections; you can then select with the CONNECTION > CONNECT TO DATABASE menu bar item.

ACS is growing on me; a work-in-progress, but it is being improved through a frequent update cycle.

HTH.
Brian.

-----Original Message----- From: Stuart Rowe
Sent: Friday, August 12, 2016 3:28 PM
To: Rational Developer for IBM i / Websphere Development Studio Client forSystem i & iSeries
Subject: [WDSCI-L] Launch Run SQL Scripts

I finally got around to trying to use this SQL script thing that only
appears if you open a SQLRPGLE member. I guess the way it is linked to the
source you are working on, that's valid.

Anyway I searched the RDi help text and the web to no avail to find out why
I can only connect to ONE system but found nothing specific to any
limitations. When I need to test a statement, it is *never* to my
development box, it's always targeting a test box where some valid data
exists so I can see if the statement works or not.

Anyone know how to get it to let me connect to other systems? I have a
connection defined (and connected) to another system but that one does not
appear in the list of systems available in the Run SQL Scripts tool. I
think it is not related to the RDi list of connections.

For now I use the old ugly one embedded in iSeries Navigator. It won't
even remember my font selections (sigh).


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.