Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of fjanon@gmail.com designates
 209.85.212.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=gXw18wioGLsk9gz8tsMN9ppGhF1RAGHoaW1H+3lK3Tjci6NfKTfGVb607fQUzt/nkk
         18ZiCibUyLBvklemTuqiK/gEE43RNLzInIYZNnQO580MiVqKoEpUINac2E8wu6RKOTwh
         ktPFU5K4XNt4tMYw40MYxR9n4oMnNo+VRjT1g=
MIME-Version: 1.0
In-Reply-To: <4C0DF839.2060503@sun.com>
References: <AANLkTilVtpK-XP3rOGJyICKCNEs-K2hDmtUgUwLXDgVO@mail.gmail.com>
	<4C0DF839.2060503@sun.com>
Date: Tue, 8 Jun 2010 16:10:55 +0800
Message-ID: <AANLkTilcBtqrXEDJsVgNkbTj88ZTUQOBfir0I0hDDqa7@mail.gmail.com>
Subject: Re: Is 'SET SCHEMA' a supported IJ command?
From: Fred Janon <fjanon@gmail.com>
To: Derby Discussion <derby-user@db.apache.org>
Content-Type: multipart/alternative; boundary=0016363b8b822912950488805419

--0016363b8b822912950488805419
Content-Type: text/plain; charset=ISO-8859-1

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
>
>

--0016363b8b822912950488805419
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

OK, great, thanks Knut.<br><br>Fred<br><br><div class=3D"gmail_quote">On Tu=
e, Jun 8, 2010 at 15:58, Knut Anders Hatlen <span dir=3D"ltr">&lt;<a href=
=3D"mailto:Knut.Hatlen@sun.com">Knut.Hatlen@sun.com</a>&gt;</span> wrote:<b=
r><blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204=
, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class=3D"h5">On 06/ 8/10 09:37 AM, Fred Janon wrote:<b=
r>
&gt; Hi,<br>
&gt;<br>
&gt; I was trying to set the &#39;default&#39; schema in ij to avoid typing=
 the<br>
&gt; schema name in front of the tables names but could not find any<br>
&gt; command to do that in the &#39;derbytools.pdf&#39; file. After searchi=
ng the<br>
&gt; mail archive, I saw mention of &#39;SET SCHEMA XXX&#39;. I tried it an=
d it<br>
&gt; seems to work but not documented.<br>
&gt;<br>
&gt; Is it really a supported command?<br>
<br>
</div></div>Hi Fred,<br>
<br>
SET SCHEMA is supported, but it&#39;s an SQL statement rather than an IJ<br=
>
command, so you&#39;ll have to look in the reference manual instead of the<=
br>
tools guide. Here&#39;s the relevant section:<br>
<a href=3D"http://db.apache.org/derby/docs/10.6/ref/rrefsqlj32268.html" tar=
get=3D"_blank">http://db.apache.org/derby/docs/10.6/ref/rrefsqlj32268.html<=
/a><br>
<br>
--<br>
<font color=3D"#888888">Knut Anders<br>
<br>
</font></blockquote></div><br>

--0016363b8b822912950488805419--