Re: Database Tooling

I couldn't get SQuirrel to update for me either Mark - that's why I kept
looking!

I _think_ you have to somehow specify the no commit option on the JBC
connection string but I could never work it out and I'm impatient! DBeaver
knew about the IBM i and seemed to handle it without any extra effort.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Apr 22, 2019, at 5:48 PM, Mark Murphy <jmarkmurphy@xxxxxxxxx> wrote:

Has anyone been able to make the in-place edit work between Squirrel and
DB2 for i? That has been one of the issues I have, SQirreL always says it
can't find the table, which is odd because it must have found the table

to

produce the output. None-the-less, the edit function does not work for

me,

and I was wondering if anyone knew the secret sauce.

Thanks Jon for mentioning dBeaver. I did install that, and it was able to
edit a result field with no special configuration. Maybe my new favorite
database tool.

On Wed, Apr 10, 2019 at 10:54 AM Mark Murphy <jmarkmurphy@xxxxxxxxx>

wrote:

I use SQuirreL client as the databases I work with are older and don't
have any referential integrity built in, and many aren't properly
normalized anyway. I find it works better than Run SQL Scripts for

general

SQL Client use. Maybe I am just used to those keystrokes. For the

things it

can't do, I use other tools, but it is rare that I need something else.

ERwin does indeed work with DB2, or did at one time. I have seen demo's
with it accessing a DB2 database on the AS400, yes, that long ago. But

it

is ex$$$pen$ive. The base version costs $300 a month, or $3000 per year.
The workgroup version costs $400 per month or $4000 per year. I still

think

these prices are per seat, there is just some extra useful

functionality.

On the plus side, there is a free trial on their web site.
https://erwin.com/products/erwin-data-modeler/

On Fri, Apr 5, 2019 at 5:30 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx>

wrote:

I'm trying to build a list of the database tools in use by our

community.

Preferably ones that actually understand that IBM i exists (even if it
calls it AS/400 or whatever).

I am familiar with IBM's Data Studio, and with dBeaver.

What other tools are folks using and what are their major features. For
example Data Studio supports a form of visual builder for SQL as does
dBeaver (in the professional version). Similarly they both support some
form of entity/relationship mapping.

What's in your toolkit?


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@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

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

list

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

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: https://amazon.midrange.com

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com