Hi Herman, Herman Timmermans [mailto:[EMAIL PROTECTED] wrote: > On Thursday 03 April 2003 15:45, Schildberg, Steffen wrote: > > Hi Marcel, > > > > [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > > is it right that you can not import via repmcli an empty > > > integer column from the data file??? Is there a possibility > > > to import nevertheless. Unfortunately, I can not fill that > > > column in my data file with a value. Thanks in advance. > > > > Hmm, I didn't get it exactly right. What do you want to do with > > an empty value for an integer column - fill a NULL value? > > You surely can't fill empty values into integer columns. > > > > Why would it not be correct if the column is not defined like > NOT NULL to > accept NULL value in case the data load file has no value for > this column? > The question was not to accept NULL values but to ensure that he wants to insert NULL. To import 'empty values' into integer columns doesn't really make sense, does it? It is of course correct to accept NULL values in case a column is defined to allow NULLs and someones request is to insert NULLs whenever an empty field in the data file for this column is found. But it has to be declared in the Loader statement that an empty values means insert NULL like this
DATALOAD TABLE <table name> <col name 1> 1 DEFAULT NULL INFILE <file name> NULL '' assuming that column <col name 1> is of type integer. I only wanted to make sure Marcel did use a statement like this which wasn't clear from its mail at all. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
