db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: AW: Problems with import of CSV to Table
Date Wed, 25 Jun 2014 12:18:47 GMT
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 (derby-user@db.apache.org)
> *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. 
> ------------------------------------------------------------------------------------------------


Mime
View raw message