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



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.



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.