Hi Marcel, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote:
> > I have a problem with the import via repmcli > > I created a data file with the following format: > > 01,01,ADP,1,1 > 02,01,AMP,1,1 > . > . > . > > and a the following command file: > > FASTLOAD TABLE test > id 1 > what 2 > dbaccession 3 > isalive 4 > ispublic 5 > > INFILE '/opt/sapdb/depend/bin/entry.data' > > In the next step I tryed to import the data via > repmcli -u <userid>,<password> -d SPECDB -b command.dat > > All the time I got that message: > > "Missing data for specified column WHAT" > > If I try to import only one column it works but not if I try to import more than one > column. > Can anyone help me. > Yes. Add the no-delimiter-spec to the infile-spec like this: FASTLOAD TABLE test id 1 what 2 dbaccession 3 isalive 4 ispublic 5 INFILE '/opt/sapdb/depend/bin/entry.data' DELIMITER '' and it'll work. You can either use delimiters in your data file (like "01","01","ADP","1","1") and in this case all data has to be delimited (btw: the default delimiter is "). Or you can use no delimiters at all as described in the command above. Well the error message tries to express that the loader has read a whole line as the data for column id (because the default delimiter is chosen and not found in the data). Thus data for column what is missing - as stated. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
