|
From: Federico B. <fed...@gm...> - 2014-09-26 16:29:09
|
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. Thanks Federico |
