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
