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



Paul, I currently do both--good to know I'm not alone!

On Wed, Mar 15, 2023 at 8:16 AM Therrien, Paul via WDSCI-L <
wdsci-l@xxxxxxxxxxxxxxxxxx> wrote:

ACS RUN SQL Scripts has one - just copy the SQL into the editor. Got to
Edit>SQL Formatter.

Our use NotePad++ and use the SQL extension SQLInForm

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Slanina,
John via WDSCI-L
Sent: Wednesday, March 15, 2023 10:45 AM
To: 'Rational Developer for IBM i' <wdsci-l@xxxxxxxxxxxxxxxxxx>
Cc: Slanina, John <jslanina@xxxxxxxxxx>
Subject: Re: [WDSCI-L] RDi: 3rd party source code formatters

I wish there was one. I keep looking for one. Let us know if you find one.

Thank
John Slanina

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Reeve
Sent: Wednesday, March 15, 2023 4:38 AM
To: wdsci-l@xxxxxxxxxxxxxxxxxx
Subject: [WDSCI-L] RDi: 3rd party source code formatters

________________________________
CAUTION: This email originated from outside of the PENCOR network. Do not
click on any links or open attachments unless the sender is known, and the
content is verified as safe.
________________________________

I'm looking for a free 3rd party source code/SQL formatter I can plug into
RDi. The built-in hasn't worked well or consistently for years and I'm on
9.6.0.12. I guess cleaning this up isn't a high priority for the RDi team.

The SQL formatting drives me bonkers. I frequently get "Could not indent
source beyond end column limit 80" messages. In addition, blank lines are
often deleted and the casing of structured opcodes usually goes to ALL
UPPER if the preceding SQL statement is malformed. The SQL formatter in
iACS is pretty good but then there's no RPG support; why not port that code?

I can take a few days and write one myself but, like everybody else, I
have other things to do. But it would be fun, so I better stop talking
about doing it before it becomes too enticing.

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




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.