Re: Launch Run SQL Scripts

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.