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.
