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 (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <28805729.post@talk.nabble.com>
Date: Mon, 7 Jun 2010 07:08:12 -0700 (PDT)
From: pb2208 <pete.beatty@gmail.com>
To: derby-user@db.apache.org
Subject: Re: Problem with Column Names
In-Reply-To: <4C0CFAA5.2050308@Sun.COM>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <28805238.post@talk.nabble.com>
 <AANLkTinth8cVE5u8y7uWJlaK9Pwp1ITnJcV0nclO5U_g@mail.gmail.com>
 <4C0CF74E.8000200@optrak.co.uk> <4C0CFAA5.2050308@Sun.COM>


You bring up an interesting point.  I was thinking about using an import for
the delimted file but ws unsure about the ability to dynamically create a
table from the file.  Is this possible?

As for the Excel files I was going to use POI to read the data.  I don't
know of an import that will import an Excel sheet from an Excel file.  Do
you know of one?


Kristian Waagan-4 wrote:
> 
> On 07.06.10 15:42, Mark Thornton wrote:
>> On 07/06/2010 14:36, Brett Wooldridge wrote:
>>> It is not valid in SQL to have column name (or other identifiers) 
>>> that begin with a numeric character.  You're going to have to code 
>>> specifically for this case.
>>>
>>>
>> Quoted identifiers are (in standard SQL) permitted to be entirely 
>> numeric.
>>
>> create table mytab ("393" decimal(3))
>>
>> should work.
> 
> This statement does work for me (tested on trunk), as does
> 
> ij> create table "999" ("393" decimal(3));
> 
> Are you sure you are quoting the identifier names correctly, both when 
> creating and accessing them?
> Also, are you created the tables/columns manually, or are you trying to 
> use an import procedure?
> 
> 
> Regards,
> -- 
> Kristian
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Problem-with-Column-Names-tp28805238p28805729.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.