Ooops, I forgot to answer the second question: Avi Schwartz [mailto:[EMAIL PROTECTED] wrote: > > Here is the loader output. BTW, is there a way to do the > "null if pos" > part > without having to put all these spaces? > Yes there is. Use the DEFAULT NULL specification. Your command would look like this:
DATALOAD TABLE selection selection_id 0001-0012 brand_id 0013-0024 DEFAULT NULL source_id 0025-0036 selection_type_id 0037-0048 selection_name 0049-0148 selection_desc 0149-1148 DEFAULT NULL image_caption 1149-1403 DEFAULT NULL image_file 1404-1453 DEFAULT NULL ... INFILE '/home/sapdb/selection.txt' NULL ' ' FORMATTED BOOLEAN 'True/False' TIMESTAMP 'YYYY-MM-DD HH:MM:SS.NNNNN' This forces the loader server to use the same NULL value specification for all specified (DEFAULT NULL) data fields. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
