× 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 figured it was related to that ACS thing -- which I cannot even download
("Server busy, try again later"). I guess I'll try again later.

Thanks all.

Stu




On Sun, Aug 14, 2016 at 1:30 PM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Yep Brian - have to agree with you on putting ACS on.


On 8/14/2016 11:01 AM, Brian Parkins wrote:

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



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