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

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