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.
Brett On Mon, Jun 7, 2010 at 10:29 PM, pb2208 <[email protected]> wrote: > > I am defining a DB where I will need to import numerous data files. These > data files may come from EXCEL, CSV files, and Tab delimited files. All of > these files use alphabetic (A-Za-z0-9) in their column names. Some columns > may contain only the (0-9) characters. > > I have been trying to create a table using the numeric characters. > However, > I am always getting exception errors pointing to the column name. The > command I am using is: > > Create Table mytab (393 decimal(3)); > > I have also tried changing the 393 to encase it in single and double > quotes. > THis has no affect. > > How can I define and reference a column using numeric characters? > > > -- > View this message in context: > http://old.nabble.com/Problem-with-Column-Names-tp28805238p28805238.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. > >
