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.
