Ok, here is the loader.prt content for that case :
// M ReplMan 7.4.3 Build 007-000-030-320 // * // M Starting protocol at 2003021700134445 // * // * // * // M START 20030217 00134445 // * set logowner sapdb // * // M START 20030217 00134445 // * set // * // M START 20030217 00134445 // * USE USER "DBADMIN" * SERVERDB "WORKDB" // * // M USER: 'DBADMIN' on DB: 'WORKDB' // * // M START 20030217 00134445 // * DATALOAD table testtable prod_no 1 name 2 title 3 barcode 4 lable 5 config_txt 6 ppd_gbp 7 ppd_iep 8 release_date 9 deletion_date 10 price_cat 11 price_code 12 new_in_cat 13 genre 14 mod_stamp 15 mod_flag 16 mod_user 17 INFILE '/home/sapdb/db_script/input.bcp' SEPARATOR '|' DELIMITER '' // * // M Error at record 1 in infile. // E -25319: Missing data for specified column DELETION_DATE. // M Last transaction committed at input record 0 // * // M Sum of inserted records 0, sum of rejected records 1 // * // M Releasing user connection (USER: 'DBADMIN'). // * The column DELETION_DATE has no value in most of the rows in input-file. So there is a gab, I have explained below. I use a sapdb 7.4 on Ret Hat 7.2 . All Client-Tools are also 7.4 . But I can't find the repserver.log > Hi Danny, > > Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote: > > > I want to fill a table with DATALOAD, but not every cell has > > a value... > > 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 : > > > > Error during execution > > -->-25319 > > Missing data for specified column test_column. > > > Please post the complete statement and the version of the server > you use (see repserver.log resp. loader.prt). > Thx, > Steffen > -- > Steffen Schildberg > SAP DB Team > SAP Labs Berlin > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ Bitte l�cheln! Fotogalerie online mit GMX ohne eigene Homepage! _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
