Re: Anyone get TOAD SQL to work for IBM DB2 for i?

On Jan 21, 2016, at 2:03 PM, Justin Dearing <zippy1981@xxxxxxxxx> wrote:

For sqlworkbench,just downoad jtopen and unzip somewhere. When you try to
make the new connection, it will complain about the missing driver, so
point it to jt400.jar. DataGrip will complain about the driver and offer to
download it for you.

There are some notes here for workbench.
http://www.sql-workbench.net/manual/dbms-problems.html#db2-problems Once
release 119 is made there will be some more notes that I've written and Tom
added, but you can search the list archive for sqlworkbench/j. I've
mentioned everything. Things do basically "just work"

On Thu, Jan 21, 2016 at 1:39 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

Justin - any recommendations for the setup for IBM i?

Like many of these tools if you don’t know the “lingo” it is just plain
confusing. I guess I’m just spoiled by tools that install complete with all
the drivers. On my Mac it doesn’t seem to be able to find a thing in the
way of drivers even though I know as a minimum I have the JT400 and MySQL
jdbc drivers on here somewhere because other tools use them.

On Jan 21, 2016, at 12:02 PM, Justin Dearing <zippy1981@xxxxxxxxx>

wrote:

I have not, and I don't use TOAD, but is there an option to specify a
custom JDBC type or does the dialog still look like this one:

http://www.toadworld.com/products/toad-mac-edition/b/weblog/archive/2013/05/30/setting-paths-to-jdbc-drivers

DB2 for i is a completely different beast from LUW, so unless a product
supports any given jdbc driver, its probably tightly coupled LUW.

I highly recommend sqlworkbench/j for talking to DB2 for i. Its really
polished and the author is really responsive. A lot of us use it on this
list. Also, JetBrains DataGrip will just work with jtopen.

Justin

On Thu, Jan 21, 2016 at 11:53 AM Matt Olson <Matt.Olson@xxxxxxxx> wrote:

Seems TOAD SQL Editor only supports LUW version of DB2 (no surprise

here).

Anyone able to hack around that limitation to get it to work for the DB2
offshoot that runs on IBM i?

Matt
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.