Re: [Squirrel-sql-users] load only one schema in a DB2 database

[Alex M. <ale...@wo...>]

You should be able to modify your alias to specify the schema (I work with iSeries):

jdbc:as400://host.domain.corp/schema;

See if that helps. Works for me.

Thank you
Alex

From: Federico Bruni [mailto:fed...@gm...]
Sent: Friday, September 26, 2014 12:29 PM
To: squ...@li...
Subject: Re: [Squirrel-sql-users] load only one schema in a DB2 database

2014-07-28 10:59 GMT+02:00 Federico Bruni <fed...@gm...<mailto:fed...@gm...>>:
Hi all
I've started using Squirrel to learn a bit of SQL.
I have a simple question that I can't figure out by myself. I'm connecting to a DB2 database which has several schemas, but I'm interested in querying only one. Currently I must specify the schema or I get an error. For example:

SELECT column FROM schema.table
works, while:

SELECT column FROM table
doesn't.
I'd like to set a certain schema to be the default to reduce the length of my SQL instructions.
IIUC I should change the properties of the alias. But I can load or not load _all_ the schemas; I cannot say "load only this schema and don't load the others". I'm missing something?
Thanks a lot in advance
Federico


I'm making a second try.
My understanding in the last paragraph above was wrong. Now I've learned how to filter a schema: I choose the alias to connect to, then click on "New Session Properties", open the tab Object tree and I enter my schema name in *Schema include*.

It works, but my problem now is that there are two identical schemas in this database. Same name, but the second is empty. Unfortunately Squirrel is loading only the empty one, as far as I can see.
How can I work around this problem?

I'm using snapshot 20140911_2017 on debian.

Thanks
Federico