|
From: Federico B. <fed...@gm...> - 2014-09-26 17:09:53
|
Il 26/set/2014 18:29 "Federico Bruni" <fed...@gm...> ha scritto: > > 2014-07-28 10:59 GMT+02:00 Federico Bruni <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. > Oops, I miss a letter, the names are different. And now the filtering is working fine. Back to the original question, I think should _load_ only this schema if I want to shorten the SQL commands |
