 | | | WG: Extract a table with NULL-values without question marks in the | WG: Extract a table with NULL-values without question marks in the 2006-07-07 - By Ralf.Bolduan@(protected)
Back
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" <R.Weisser@(protected)>
07.07.2006 08:58
An
maxdb@(protected)
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/maxdb?unsub=ralf.bolduan@(protected)
|
|
|