OK, great, thanks Knut.

Fred

On Tue, Jun 8, 2010 at 15:58, Knut Anders Hatlen <Knut.Hatlen@sun.com> wrote:
On 06/ 8/10 09:37 AM, Fred Janon wrote:
> Hi,
>
> I was trying to set the 'default' schema in ij to avoid typing the
> schema name in front of the tables names but could not find any
> command to do that in the 'derbytools.pdf' file. After searching the
> mail archive, I saw mention of 'SET SCHEMA XXX'. I tried it and it
> seems to work but not documented.
>
> Is it really a supported command?

Hi Fred,

SET SCHEMA is supported, but it's an SQL statement rather than an IJ
command, so you'll have to look in the reference manual instead of the
tools guide. Here's the relevant section:
http://db.apache.org/derby/docs/10.6/ref/rrefsqlj32268.html

--
Knut Anders