[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    Fwd: Extract a table with NULL-values without question marks in the
From:       "Robert Klemme" <shortcutter () googlemail ! com>
Date:       2006-07-07 7:39:57
Message-ID: 9e3fd2c80607070039k2433b36bpe6045910d7081eef () mail ! gmail ! com
[Download RAW message or body]

---------- Forwarded message ----------
From: Robert Klemme <shortcutter@googlemail.com>
Date: 07.07.2006 09:39
Subject: Re: Extract a table with NULL-values without question marks in the
To: "Ralf.Bolduan@enercon.de" <Ralf.Bolduan@enercon.de>


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, Ralf.Bolduan@enercon.de <Ralf.Bolduan@enercon.de>:
> 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@gmx.de>
> 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/maxdb?unsub=ralf.bolduan@enercon.de
>
>
>


--
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/maxdb?unsub=sapdb-general@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]