MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2013

Re: Squirrel not showing list of tables



fixed

Vern,

Thanks for trying SquirrelSQL. I've found it to be my most used tool over the last 10+ years, of course I'm a i5 DB2 engineer.

In SquirrelSQL, click on the Aliases tab on the left, right click your alias and select alias properties. On the 1st tab (Schemas), highlight the 3rd radio button. (Specify Schema loading and caching) Now click the button below. (Connect database to refresh Schema table). Next, make sure that the pull down below, the schema table which was just populated, is set to All Object & Load but don't cache and click Apply. Locate the schemas (library) you wan to be able to view the details, and change Tables, Views and Procedures columns to Load but don't cache. Do not click any other buttons until you are done, then click OK.

Jim

Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx> wrote:

I'm trying out Squirrel - I'm probably miscasting an entity relationship
into what I want - mapping between input and output files in RPG.

Anyhow, I installed Squirrel - I'm on 64-bit Win7. It's the latest
Squirrel - 3.5.0. I did install the optional DB2 plugin, as recommended
by Thomas Snyder in an article from a while ago at MC Press online.

I made a driver for JT400 - and an alias for our development (7.1) LPAR.

The schemas are all listed - not just the one I named in the connection
string.

When I click on the thingy next to a schema, it opens to a list of
object types - TABLE, VIEW, etc.

When I click on the thingy next to TABLE, nothing.

I've done a little digging - there was apparently an issue with DB2
databases at 3.4.0 of Squirrel - shouldn't they have fixed it for the
later release?

So I assume there's something awry with me. No comments!
--
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.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact