Re: New RDi. Lost my favorite feature.

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@xxxxxxxxxxxxxxxxx

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.