Hi,
I removed the first double quote character and the data got inserted
without error.
From this experimentation I assume the double quote character is the
default stop delimiter?
Any suggestions as to the best way to get data such as this inserted?
I could parse the tab delimited data and remove all double quote
characters then somehow insert them again once they are in the
database but this seems rather clumsy and error prone.
Any advice would be greatly appreciated.
Cheers, Tim
On 12 Jan 2007, at 12:07, Tim Troup wrote:
Hi,
I am trying to load a tab delimited text file into a database table
in derby 10.2.1.6 using the following command in ij:
CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (null,'pg_synonyms','/Users/
troup/data/biomint/pg_synonyms',' ',null,null,0);
However I keep getting the following error:
ERROR 38000: The exception 'java.sql.SQLException: Data found on
line 8,238,195 for column 2 after the stop delimiter.' was thrown
while evaluating an expression. SQLSTATE: XIE03: Data found on line
8238195 for column 2 after the stop delimiter.
What is the default stop delimiter?
I have analysed the file contents and this line has double quotes
round a word in the column two data:
"Gu" protein
no other line preceding this one has double quotes round any word
so this made me suspect this was what is causing the load error.
Any advice would be greatly appreciated.
Best regards,
Tim Troup
