Re: Refresh IFS file contents?

On Sep 13, 2018, at 2:11 PM, Ken Killian <kkillian@xxxxxxxxxxxx> wrote:

Thanks Roger!

I happen to use SquirrelSQL.org with much success! And I can cut & paste sample data as an "INSERT" into my required Test-Case in SQLRPGLE code. But, still limited by Punch-Card column 100. Darn it! So, I have truncate it punch-card column 100.

Many sql client tools have that capability! Just a pain to format sql to fit into 100-column punch-cards for my QRPGLESRC source files. Bummer!


-Ken Killian-


-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> On Behalf Of Roger Harman
Sent: Thursday, September 13, 2018 1:43 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?

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