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



Thanks Justin.

The interface is kind of funky but it it does seem to be very fast. Be interesting to compare it with IBM’s Data Studio which I like mostly for the wizards (when I can get them to work).


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.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com


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.