Hi Arne,
Arne Gehlhaar wrote > > I've got one more question concering the Replication Manager. > If I use > the compressed format with DELIMITER '"' and SEPARATOR ',' > for dataload, > what is the correct syntax of null values ? or "?". If my input file > contains just ? I get "Missing data for specified column > XYZ". If I use > "?" then my table will contain the question mark '?' instead > of null values. > the second is the correct syntax - all data has to be included in delimiters. The problem is rather the command. To have the RepMan recognize a value as NULL value representation in the data file you need to declare that value in the command like this DATALOAD TABLE <table name> <column name> <pos> DEFAULT NULL <-- make the RepMan expecting NULL values for this col INFILE <file name> supposing you're using the default NULL value representation (question mark). If you use your own NULL value representation, for instance hash mark # your command could look like this DATALOAD TABLE <table name> <column name> <pos> DEFAULT NULL INFILE <file name> NULL '#' The last NULL definition overwrites the RepMan NULL value representation. Or the statement could look like this DATALOAD TABLE <table name> <column name> <pos> NULL IF POS <pos>='#' INFILE <file name> I'd prefer the first two. But be aware of the fact that in the first two examples the NULL value representation is the same for all columns whereas you might specify different representations for all columns in the latter example. Could I make it clear? I think this is another item for a HowTo in the docs, isn't it. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
