Hi Steffen, I have tried the solution with DEFAULT NULL for the boolean columns - and it works fine!
Thanks a lot for your help, Thomas >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]
