Hi Thomas,
well, yes it is a bug in handling multiple boolean values if more than
one of them are
evaluated to a null condition.
You can overcome this problem by using the following syntax - I hope it
is
an applicable solution for you.

import table testtab
update duplicates
data instream file 'test.dat'
NULL 'NULL'
id 1
field1 2 DEFAULT NULL
field2 3 DEFAULT NULL

If you're familiar with ADABAS this DEFAULT NULL should be known. You
need
to mark all columns that you expect NULL values for with DEFAULT NULL.
This
will work if you have the same NULL value representation for all fields
in
your data file.

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]

Reply via email to