|
From: Samuel J L. <len...@ho...> - 2014-09-30 21:03:35
|
Have you considered caching schemas in the alias properties? I'm not sure exactly of the issue, but maybe it is taking a long time to load all the schemas? If so, I believe you can load and cache the schemas once, then change to not load schemas, so next time you start SQuirrel the Schemas will be loaded from the cache. Another variation is once you have all the schemas loaded, you can specify which to load. But you need to load all the schemas at least once to get a list you can subset. Sam (With OS/400 in the IBM i - iSeries - AS/400 world each library is considered a schema.) Date: Tue, 30 Sep 2014 18:18:21 +0200 From: fed...@gm... To: squ...@li... Subject: Re: [Squirrel-sql-users] load only one schema in a DB2 database 2014-09-26 18:29 GMT+02:00 Federico Bruni <fed...@gm...>: 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 was not wrong actually, I was just confused by two different settings preferences (alias properties and session properties). Alias schema properties seem exactly what I want, but I confirm the problem I described before: I can load or not load _all_ the schemas; I cannot say "load only this schema and don't load the others". ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
