Hi Georg, there is a little mistake in the docs describing the null value specification in load commands with the 'SET NULL' command. It is not enough to specify the NULL specifier with 'SET NULL' command but you must also mark all columns allowing NULLs in the data with DEFAULT NULL (I'm sure this feature exists in ADABAS,too). Furthermore there is a problem with empty fields in the data. Even empty fields must be included in delimiters (or you run it without delimiters at al if xload allows it during extracting the data). So your command file could look this way
SET NULL '?' / DATALOAD TABLE &1 "FIELD1" 1 "FIELD2" 2 "FIELD3" 3 "FIELD4" 4 "FIELD5" 5 "FIELD6" 6 "FIELD7" 7 "FIELD8" 8 DEFAULT NULL "FIELD9" 9 DEFAULT NULL "FIELD10" 10 "FIELD11" 11 "FIELD12" 12 DEFAULT NULL INFILE 'userdata.dat' separator '|' Your data should look like this "1"|"A"|"A"|"1"|"111"|"111"|"111"|"?"|"?"|"FALSE"|"XXX"|"?" I would suggest to work with a question mark as null spec during extract and load. I know the handling of empty fields is kind of inconvinient. I thought I solved this problem already in an earlier version. But introducing a new pattern search seems to have it brought back on the table. I'll work on it. Let me know if I can help further. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
