Hi List, after having some conversation with Noah outside the list the following was the solution to the encountered problem (it's simply my answer to Noah):
Your statement looks like this (I include only the last 2 lines as one of those causes the problem: DATALOAD TABLE LD_TABLE UPDATE DUPLICATES ... LD_SN 10 DEFAULT NULL LD_ET 11 DEFAULT NULL INFILE 'F:\prd\data\import.csv' COMPRESSED SEPARATOR ';' DELIMITER '' Your data is as follows if it causes the problem (correct me if I'm wrong): <data1>;<data2>;<data3>;;<data5>;;;;<data9>;;<data11> And here it comes: you don't redefine the NULL value representation used by the Loader but use the Loader default (may be the syntax element DEFAULT NULL is here kind of confusing). The term DEFAULT in the above mentioned syntax element means: the Loader uses one and only one NULL value representation for all columns in the command where the DEFAULT NULL element is specified. But one can of course (and in your case I'd say: has to) change this representation for that single command. May be we should replace DEFAULT NULL by something like SINGLE NULL or similar ... Well, so if I see it right you'd like to have the empty value as the NULL value representation in your data? But the Loader uses the internal default value (thats the question mark '?'). As you wrote in one of the first mails your commands worked if you had to load char columns with NULLs. You should check if those columns contain really NULLs or rather the empty value after successfully loading. Back to your command. If you'd like to have empty values interpreted as NULLs for certain columns (those having the DEFAULT NULL specified as for your LS_SN column) when loading the data your command should look like this: DATALOAD TABLE LD_TABLE UPDATE DUPLICATES ... LD_SN 10 DEFAULT NULL LD_ET 11 DEFAULT NULL INFILE 'F:\prd\data\import.csv' COMPRESSED SEPARATOR ';' DELIMITER '' NULL '' And if you'd now prefer the solution with the 0s in the data file - here comes the command that should do the job: DATALOAD TABLE LD_TABLE UPDATE DUPLICATES ... LD_SN 10 DEFAULT NULL LD_ET 11 DEFAULT NULL INFILE 'F:\prd\data\import.csv' COMPRESSED SEPARATOR ';' DELIMITER '' NULL '0' Best regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
