Re: New RDi. Lost my favorite feature.

Thank you sir. I very much appreciate the info. I have not used that tool. So I'm unfamiliar. But knowing it has that feature is enough. I will figure it out. I see that the ability to "save results" must be configured and is not the default. Looks like this will do the job. Thanks again.


-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Therrien, Paul via WDSCI-L
Sent: Friday, April 28, 2023 10:43
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Cc: Therrien, Paul <ptherrien@xxxxxxxxxxx>
Subject: Re: [WDSCI-L] New RDi. Lost my favorite feature.

ACS SQL Client downloads to excel by right-clicking on the results tab and selecting 'Save Results'. Available for quite some time.


-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Elden Fenison
Sent: Friday, April 28, 2023 1:40 PM
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] New RDi. Lost my favorite feature.

IBM said "merely updating" was not an option. This is a new version intended for a clean install.

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of x y
Sent: Friday, April 28, 2023 10:34
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] New RDi. Lost my favorite feature.

Not having that problem here. There are some settings for this feature that may have been lost if you did a clean install. I merely updated and didn't lose anything: right-click on the output and "Save results" is open for business.

On Fri, Apr 28, 2023 at 10:18 AM Elden Fenison < Elden.Fenison@xxxxxxxxxxxxxxxxx> wrote:

One of the best features of the built-in SQL editor in the old RDi...
was the ability to easily export results to Excel. iACS doesn't seem to do this.


-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Daniel
Gross
Sent: Friday, April 28, 2023 10:16
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] New RDi. Lost my favorite feature.

Well yes - I use the iACS run sql script feature.

Essentially because it’s quite good, has a big library of snippets and
can also run CL commands.

With 1.1.9.2 it even can prompt for “host variables” in the statement
like

where table.col = :myVar

OK - this is old for DBeaver, but new to iACS.

HTH
Daniel

Am 28.04.2023 um 18:50 schrieb Elden Fenison <

Elden.Fenison@xxxxxxxxxxxxxxxxx>:

For me, RDi was my SQL tool of choice. I had several large "scratch

pads" of SQL code that I regularly referred to and executed directly
from RDi. One could set the file association for .sql files to be one
of three built-in SQL tools. These all seem to be gone.

I am guessing that this was not the SQL tool of choice for many, or
else

they would not have removed the feature. What should I be using instead...
Access Client Solutions?

[cid:image001.jpg@01D979B5.CC344780]
Elden Fenison
Programmer/Analyst
Murphy Company
elden.fenison@xxxxxxxxxxxxxxxxx<mailto:elden.fenison@murphyplywood.c
om

541-461-1304

--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/wdsci-l.

--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/wdsci-l.


--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/wdsci-l.