---------- Forwarded message ---------- From: Robert Klemme <[EMAIL PROTECTED]> Date: 07.07.2006 09:39 Subject: Re: Extract a table with NULL-values without question marks in the To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
You probably should also mention that the "Loader" you are referring to is not the Java too the OP wrote. Ralf, MaxDB comes with a loader that performs exactly these tasks, i.e. data export and import. Please see the documentation for details. The loader is also capable of creating the table. Kind regards robert 2006/7/7, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hi, Mr. Weisser, maybe this could solve it. Add this NULL - Value - Interpretation directive (the other definitions may be different...) to the bottom of the .command - File, that is parsed by the loader. ... INSTREAM FILE 'some_table.data' COMPRESSED UTF8 DECIMAL '//./' SEPARATOR ',' DELIMITER '"' DATE INTERNAL TIME INTERNAL TIMESTAMP INTERNAL NULL '? ' BOOLEAN 'TRUE/FALSE' Freundliche Grüße Ralf Bolduan ----- Weitergeleitet von Ralf Bolduan/Enercon am 07.07.2006 09:01 ----- "Ralf Udo Weisser" <[EMAIL PROTECTED]> 07.07.2006 08:58 An maxdb@lists.mysql.com Kopie Thema Extract a table with NULL-values without question marks in the Hello, who can help me with this Problem: My aim: I want do transfer an table from one MaxDB instance to an other for testing. So I coded an small Java-program with the Java-Class "Loader", which is produced by MaxDB-programer. In this class I can extract an defined table from one DB-instance in a data-file. This data-file,which is like a text-file, I can import on an analog way with a loading-command in another DB-instance. My problem: If there are NULL-values in the table, the extracted data-file contents question marks for NULL-values instead of space character. If I want to load this data-file with the loader-class, I alway get a exception, because the datatype for this colum is not compatible with strings. My Question: Can I make an setting, which defines, how NULL-values are extracted in a data-file? Thank you very much for you help. Ralf -- "Feel free" ? 10 GB Mailbox, 100 FreeSMS/Monat ... Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Have a look: http://www.flickr.com/photos/fussel-foto/ -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
