Hi,
thanks!! Robert Klemme gave me already a similar hint.
I should have seen the obvious ;-)
kind regards
Frank
To
<[email protected]>
cc
"Schildberg,
Steffen" Subject
AW: Loader: -25301 Invalid input
08.06.2005 13:48 for date or time column: ?
Classification
Hi Frank,
Frank Schimmelpfennig [mailto:[EMAIL PROTECTED] wrote:
>
> I have a compressed textfile gsa.dat containing several lines
> of the format (pls. see below)
>
> gsa.dat:
> 1;1;1;268435455;05.05.2005;?;?
> 2;2;132192484;139999999;05.05.2005;?;?
> 3;2;233982849;234999999;05.05.2005;?;?
>
> When I want to load the data with the Loader utility.
> Unfortunately I get a
> -25301 error (command and system message pls. below). What is
> wrong with my
> date specification? Is there someone who can give a hint?
>
>
> DATALOAD TABLE gsa_tab
> UPDATE DUPLICATES
> gsa_id 1
> dty_id 2
> min_snr 3
> max_snr 4
> start_date 5
> end_date 6
> description 7
> INSTREAM 'gsa.dat'
> COMPRESSED
> DELIMITER ''
> SEPARATOR ';'
> DATE EUR
> Error during execution
> -->-25301
> Invalid input for date or time column: ?
>
The question sign acts a NULL value specification. You should change
your
load command as follows:
DATALOAD TABLE gsa_tab
UPDATE DUPLICATES
gsa_id 1
dty_id 2
min_snr 3
max_snr 4
start_date 5
end_date 6 DEFAULT NULL
description 7 DEFAULT NULL
INSTREAM 'gsa.dat'
COMPRESSED
DELIMITER ''
SEPARATOR ';'
DATE EUR
and it'll do. This way you inform the Loader about the fact that it has
to
interpret a question sign (the default NULL value specification in data
files) for fields 6 and 7 as a NULL value rather than a real value.
Regards,
Steffen
--
Steffen Schildberg
MaxDB Team
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
