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



Yes to both. I have connection profiles setup for DB2 (Dev & Prod) as well as SQL Server and Oracle.

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 12:39 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Refresh IFS file contents?
 
Roger,

Normally, I agree! But, I am manually load test dummy data for Test-Case using RPG-UNIT. As required.

Does SQL Workbench give you content assist for IBM I DB2? Does it work with IBM i DB2?

-Ken Killian-


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

I'll have to try that.  But...  SQL Workbench gives me content assist and more.

As to the 100 column limitation - Personal preference - I would find 100 columns of SQL cumbersome to read/interpret.  I'd rather have the statement broken up into smaller chunks (width-wise).

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 11:43 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Refresh IFS file contents?
 
Arco,

Wow! WONDERFUL! This will save me tons of time!!!

Just installed it in NotePad++ and works WONDERFULLY!!!

Thank you! <Over-Joyed!>

-Ken Killian-


-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> On Behalf Of Arco Simonse
Sent: Thursday, September 13, 2018 2:37 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?

Hi Ken,

Do you know the Poor Man's t SQL formatter plugin for Notepad++ ?
You can set the maximum width of the formatted code.
I do use it all day. Great tool.

Best regards,
-Arco

Op donderdag 13 september 2018 heeft Ken Killian <kkillian@xxxxxxxxxxxx> het volgende geschreven:

Just a pain to format sql to fit into 100-column punch-cards for my
QRPGLESRC source files. Bummer!

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

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.