Return-Path: 
 <derby-user-return-9681-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 34761 invoked from network); 22 Aug 2008 13:12:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 22 Aug 2008 13:12:25 -0000
Received: (qmail 61110 invoked by uid 500); 22 Aug 2008 13:12:22 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 61091 invoked by uid 500); 22 Aug 2008 13:12:22 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 61080 invoked by uid 99); 22 Aug 2008 13:12:22 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Aug 2008 06:12:22 -0700
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of bruehlicke@gmail.com
 designates 209.85.217.12 as permitted sender)
Received: from [209.85.217.12] (HELO mail-gx0-f12.google.com) (209.85.217.12)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Aug 2008 13:11:23 +0000
Received: by gxk5 with SMTP id 5so1058166gxk.7
        for <derby-user@db.apache.org>; Fri, 22 Aug 2008 06:10:52 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to
         :subject:in-reply-to:mime-version:content-type:references;
        bh=8ChCG5V12G60lCbASNsFJeYHCARUBQoe53hRN4gxj9E=;
        b=eIc8nj1si22hrGm+mBdhg6/deLwCMV31b1jg9VuXcm0XWkZwxFvFMstpZXMBK1i2fP
         foa7GqNYsJW29rBfi6h2CRBN0uu/fbH4TP+2NC4lkv2nYX/x5VyU4v6PI3JKDJPA/fnC
         o/M9sKesGiq8slVkQs0MtNPgaUu4Lax6MVlnM=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=cwvC1OwpyObfx5M+SaK1o4XiqYOpobVx4ZVQrz+DvqdcJLMoT4OyTTCtc71KujczhW
         HJlxBlSx27jQHjPXT2DrBs1GTDTsM793LjCVK7KyR/oZ3XoDeYrZeJKpFVruVEEVqINr
         4TByTFrmrjdxiTiq/Uytjv9YaqcHmP3Gck40I=
Received: by 10.151.42.20 with SMTP id u20mr1769716ybj.231.1219410652226;
        Fri, 22 Aug 2008 06:10:52 -0700 (PDT)
Received: by 10.151.45.18 with HTTP; Fri, 22 Aug 2008 06:10:52 -0700 (PDT)
Message-ID: <6ac05c90808220610r6bde00a9g40687b7b418ad026@mail.gmail.com>
Date: Fri, 22 Aug 2008 08:10:52 -0500
From: bruehlicke <bruehlicke@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Show Tables command is not working with ij Tool
In-Reply-To: <19105443.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_34487_34529.1219410652218"
References: <19105443.post@talk.nabble.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_34487_34529.1219410652218
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I am using Derby 10.4.1.3

Using ij I can confirm that "show tables;"  and "describe <tablename>";
works  for example:

ij> show tables;
TABLE_SCHEM         |TABLE_NAME                    |REMARKS
------------------------------------------------------------------------
SYS                 |SYSALIASES                    |
SYS                 |SYSCHECKS                     |
SYS                 |SYSCOLPERMS                   |
SYS                 |SYSCOLUMNS                    |
SYS                 |SYSCONGLOMERATES              |
SYS                 |SYSCONSTRAINTS                |
SYS                 |SYSDEPENDS                    |
SYS                 |SYSFILES                      |



ij> describe sys.syscolumns;
COLUMN_NAME
|TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
REFERENCEID         |CHAR     |NULL|NULL|36    |NULL      |72        |NO
COLUMNNAME          |VARCHAR  |NULL|NULL|128   |NULL      |256       |NO
COLUMNNUMBER        |INTEGER  |0   |10  |10    |NULL      |NULL      |NO
COLUMNDATATYPE      |org.apac&|NULL|NULL|-1    |NULL      |NULL      |NO
COLUMNDEFAULT       |java.io.&|NULL|NULL|-1    |NULL      |NULL      |YES
COLUMNDEFAULTID     |CHAR     |NULL|NULL|36    |NULL      |72        |YES
AUTOINCREMENTVALUE  |BIGINT   |0   |10  |19    |NULL      |NULL      |YES
AUTOINCREMENTSTART  |BIGINT   |0   |10  |19    |NULL      |NULL      |YES
AUTOINCREMENTINC    |BIGINT   |0   |10  |19    |NULL      |NULL      |YES

9 rows selected

Hope this helps.

B-)



On Fri, Aug 22, 2008 at 6:24 AM, munugalaramesh <ramesh.yem@gmail.com>wrote:

>
> Dear All,
>
>  Can any one help on this.
>
>  I integrated ij tool with Eclipse (Europa) according to Apache Derby
> documentation.
>
>  I tried with the following commands,all of them are not working
>
>  show tables;
> describe tables;
> show schemas;
>
>  I am getting folowing error
>
> ERROR 42X01: Syntax error: Encountered "describe" at line 1, column 1.
>
> Advance thanks
>
>
>
> --
> View this message in context:
> http://www.nabble.com/Show-Tables-command-is-not-working-with-ij-Tool-tp19105443p19105443.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>
>

------=_Part_34487_34529.1219410652218
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">I am using Derby <a href="http://10.4.1.3">10.4.1.3</a> <br><br>Using ij I can confirm that &quot;show tables;&quot;&nbsp; and &quot;describe &lt;tablename&gt;&quot;; works&nbsp; for example:<br><br>ij&gt; show tables;<br>
TABLE_SCHEM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |TABLE_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |REMARKS<br>------------------------------------------------------------------------<br>SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |SYSALIASES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br>SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |SYSCHECKS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br>
SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |SYSCOLPERMS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br>SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |SYSCOLUMNS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br>SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |SYSCONGLOMERATES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br>SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |SYSCONSTRAINTS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br>
SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |SYSDEPENDS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br>SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |SYSFILES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br><br><br><br>ij&gt; describe sys.syscolumns;<br>COLUMN_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |TYPE_NAME|DEC&amp;|NUM&amp;|COLUM&amp;|COLUMN_DEF|CHAR_OCTE&amp;|IS_NULL&amp;<br>
------------------------------------------------------------------------------<br>REFERENCEID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |CHAR&nbsp;&nbsp;&nbsp;&nbsp; |NULL|NULL|36&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |72&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NO<br>COLUMNNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |VARCHAR&nbsp; |NULL|NULL|128&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |256&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NO<br>
COLUMNNUMBER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |INTEGER&nbsp; |0&nbsp;&nbsp; |10&nbsp; |10&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NO<br>COLUMNDATATYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |org.apac&amp;|NULL|NULL|-1&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NO<br>COLUMNDEFAULT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |java.io.&amp;|NULL|NULL|-1&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |YES<br>
COLUMNDEFAULTID&nbsp;&nbsp;&nbsp;&nbsp; |CHAR&nbsp;&nbsp;&nbsp;&nbsp; |NULL|NULL|36&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |72&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |YES<br>AUTOINCREMENTVALUE&nbsp; |BIGINT&nbsp;&nbsp; |0&nbsp;&nbsp; |10&nbsp; |19&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |YES<br>AUTOINCREMENTSTART&nbsp; |BIGINT&nbsp;&nbsp; |0&nbsp;&nbsp; |10&nbsp; |19&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |YES<br>
AUTOINCREMENTINC&nbsp;&nbsp;&nbsp; |BIGINT&nbsp;&nbsp; |0&nbsp;&nbsp; |10&nbsp; |19&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |YES<br><br>9 rows selected<br><br>Hope this helps.<br><br>B-)<br><br><br><br><div class="gmail_quote">On Fri, Aug 22, 2008 at 6:24 AM, munugalaramesh <span dir="ltr">&lt;<a href="mailto:ramesh.yem@gmail.com">ramesh.yem@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
Dear All,<br>
<br>
&nbsp;Can any one help on this.<br>
<br>
&nbsp;I integrated ij tool with Eclipse (Europa) according to Apache Derby<br>
documentation.<br>
<br>
&nbsp;I tried with the following commands,all of them are not working<br>
<br>
&nbsp;show tables;<br>
describe tables;<br>
show schemas;<br>
<br>
&nbsp;I am getting folowing error<br>
<br>
ERROR 42X01: Syntax error: Encountered &quot;describe&quot; at line 1, column 1.<br>
<br>
Advance thanks<br>
<font color="#888888"><br>
<br>
<br>
--<br>
View this message in context: <a href="http://www.nabble.com/Show-Tables-command-is-not-working-with-ij-Tool-tp19105443p19105443.html" target="_blank">http://www.nabble.com/Show-Tables-command-is-not-working-with-ij-Tool-tp19105443p19105443.html</a><br>

Sent from the Apache Derby Users mailing list archive at Nabble.com.<br>
<br>
</font></blockquote></div><br></div>

------=_Part_34487_34529.1219410652218--