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