Hi Danny, Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote: > > I have installed the new Loadercli and repaced the lserver . > After that I > set the s-bit and made a restart of the x_server. > > Then I set the database-status to "warm" and want to fill a table with > DATALOAD, > but not every cell has a value (in the input file)... > So I have a Input-file with some gabs, like this example of > an input-file : > > 01045415487|Dream|Private||20010917172028950000 > > You see, that column 4 has no value. > > But then DATALOAD says again : > > Error during execution > -->-25319 > Missing data for specified column test_column. > > I have tested the repmcli and the new loadercli, but always > the same error. > So it is a must to have a value in every Column, so that I > have to fill the empty columns with ' ' or something like that ? > Empty values are allowed so far only for char data type columns (it wouldn't make a difference to put blanks into those fields). If you're about to fill an empty value in a column of another data type the error above described is thrown. The question here is: how is your table especially your date column defined - allowing NULLs or not? And what do you intend to insert into a date column if the value read is empty - NULL? But anyway with the published releases you won't get loaded empty fields into date columns. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
