Try using something like SQL Workbench/J or copy/paste to/from an online SQL formatter. You can set your preferences for style.
I sue SQL Workbench/J all the time. I can output to text (various delimiters) or XLSX as needed.
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> on behalf of Ken Killian <kkillian@xxxxxxxxxxxx>
Sent: Thursday, September 13, 2018 4:49 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Refresh IFS file contents?
OH yeah, since "currently" LPEX handles line splitting TERRIBLE for SQL Statements. Where I have to split the line with Alt+S, instead of the normal <Enter>. And then use the back-space key to line up the split the line to the starting column. Edit big/huge SQL statements in LPEX is a ROYAL PAIN is the A@@. :(
So, I instead edit with NotePad++, and then RDI tells me that my source needs to be refresh.
Gee, I did not think hitting <ENTER> to split a line and line up columns was "Rocket Science". But, that is CURRENT LIMITATION of LPEX. Oh well, NotePad++ to rescue! Again! <Joy Joy>
-Ken Killian-
-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> On Behalf Of Greg Wilburn
Sent: Wednesday, September 12, 2018 4:38 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Refresh IFS file contents?
Yes. With Notepad++ You'll get a notification that the file changed and do you want to reload it.
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Wednesday, September 12, 2018 4:30 PM
To: Wdsci-L <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Refresh IFS file contents?
How does that help? Does it do a refresh any time the underlying file changes? Surprising if it does.
Jon Paris
www.partner400.com
www.SystemiDeveloper.com
On Sep 12, 2018, at 1:45 PM, Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
Notepad++
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of
Justin Taylor
Sent: Wednesday, September 12, 2018 12:51 PM
To: Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: [WDSCI-L] Refresh IFS file contents?
If I open an IFS file in RDi, and the contents change, the only way I know of the refresh the editor is to close and reopen the file. Is there an easier way to do this?
TIA
--
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: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx 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 / 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: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx 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 / 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:
https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
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 / 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:
https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/wdsci-l.
midrange.com
