|
From: Federico B. <fed...@gm...> - 2014-10-01 12:06:28
|
Maybe my issue is a non-issue. I don't have any knowledge of databases, so I may use wrong words and have wrong expectations. Squirrel query builder is not working because it doesn't include the schema name in the queries. This is at least my assumption because I get the same error if I don't specify the schema in my SQL instructions. This works: SELECT PROGRESSIVO FROM SCHEMA-NAME.ARTICOLO This doesn't: SELECT PROGRESSIVO FROM ARTICOLO Error: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2INST1.ARTICOLO, DRIVER=3.57.82 SQLState: 42704 ErrorCode: -204 Error: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;DB2INST1.ARTICOLO, DRIVER=3.57.82 SQLState: 56098 ErrorCode: -727 I guess I'll have to go the hard way, use a terminal and learn the SQL commands. Thanks anyway Sam 2014-09-30 23:03 GMT+02:00 Samuel J Lennon <len...@ho...>: > 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 > |
