I found my problem now, it was a not existing file for input, I had overseen in the error report. FEHLER XIE04: Nicht gefundene Datendatei: memorecords.dat
But I have also another question. When I tried to give nulls in the import export statement using the procedures, ij gave me an syntax error. What do I need to do that ij accepts my null-values for using the defaults? Thanks for hints Malte Von: Kempff, Malte Gesendet: Dienstag, 24. Juni 2014 17:21 An: Derby Discussion ([email protected]) Betreff: Problems with import of CSV to Table Hi, I have this Table ij(DB_8_2)> describe memo_records; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& ------------------------------------------------------------------------------ RECORD_ID |VARCHAR |NULL|NULL|512 |NULL |1024 |NO INPUTFILE_ID |INTEGER |0 |10 |10 |NULL |NULL |YES TMPST_IN |TIMESTAMP|9 |10 |29 |CURRENT_T&|NULL |NO TMPST_USED |TIMESTAMP|9 |10 |29 |NULL |NULL |YES STATE |CHAR |NULL|NULL|1 |'I' |2 |NO And I have this CSV-Structure for importing it. "174145"|1382|"2014-03-28 05:09:44.441"||"I" "174146"|1382|"2014-03-28 05:09:44.558"||"I" "174147"|1382|"2014-03-28 05:09:44.585"||"I" "174507"|1424|"2014-04-07 05:09:56.649"|"2014-04-10 18:11:45.388"|"U" "174508"|1424|"2014-04-07 05:09:56.738"||"I" I am getting this Error in ij: FEHLER 38000: Bei der Auswertung eines Ausdrucks wurde die Ausnahme 'java.sql.SQLException: Bei der Auswertung eines Ausdrucks wurde die Ausnahme 'java.lang.reflect.InvocationTargetException' ausgel÷st.' ausgel÷st. FEHLER 38000: Bei der Auswertung eines Ausdrucks wurde die Ausnahme 'java.lang.reflect.InvocationTargetException' ausgel÷st. Well actually I cannot find the problem, I suspect that it might be the date. But shouldn't an export produce csv correctly for the import? Here is the Statement for export: call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select RECORD_ID ,INPUTFILE_ID ,TMPST_IN ,TMPST_USED ,STATE from memo_records ', 'memorecords.dat', '|', '"', 'utf8'); And here is my statement for import: call syscs_util.syscs_import_table ('APP', 'MEMO_RECORDS', 'memorecords.dat', '|', '"', 'utf8',0); I am using right now 10.8.2 needing to migrate down to 10.1.1.0 (crazy, isn't it?). Got somebody an idea what I could do here to solve the problem? Thanks a lot in advance Malte ------------------------------------------------------------------------------------------------ Disclaimer: The contents of this electronic mail message are only binding upon Equens or its affiliates, if the contents of the message are accompanied by a lawfully recognised type of signature. The contents of this electronic mail message are privileged and confidential and are intended only for use by the addressee. If you have received this electronic mail message by error, please notify the sender and delete the message without taking notices of its content, reproducing it and using it in any way. ------------------------------------------------------------------------------------------------
