Since we are talking SQL plug-ins for RDi, I'd like to add my two cents
worth.
I use DBeaver for both my stand-alone SQL software and there is also an RDi
plug-in for DBeaver. That way whether I launch a tab within RDi, or a run
my full screen SQL editor, it is the same one. Same functionality.
There is a free version and a pay version (one-time, lifetime fee, I
believe) and they update the software on a very regular basis. I attach to
DB2, Oracle, and SQL Server with it without any issues and it does offer
column listings on the DB2 tables, like and Oracle Developer does on Oracle
tables.
Just one more option out there that's a great (free) SQL package for use in
RDi.
Steve Meisinger
-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> On Behalf Of Greg Wilburn
Sent: Thursday, September 13, 2018 2:40 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 hate to ask..
What is SQL Workbench? Is that part of RDi?
I'm currently using Data Studio plugin for RDi, and I don't like it. I do
like Run SQL Scripts in IBM ACS.
-----Original Message-----
From: WDSCI-L [mailto: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.
--
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
