Re: Database Tooling

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

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