On 6/24/14 8:45 AM, Kempff, Malte wrote:
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.
Hi Malte,
Can you post the import or export statement which is failing, along with
the error? The user documentation for SYSCS_UTIL.SYSCS_IMPORT_TABLE says
that all of the arguments are nullable except for TABLENAME, FILENAME,
and REPLACE.
Thanks,
-Rick
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.
------------------------------------------------------------------------------------------------
