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

[Federico B. <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