Hi David,
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > Hi Steffen, All, > > Following my recent post regarding using repmcli to extract > and then load > our data, I have found what appears to be a bug. I use > repmcli to export the data, and then import it back again. > > Everything works great, except if one of the fields contains > a VARCHAR that > contains a newline character (we receive the data entered through a > website, and store it in the database). > > In this case, it will not import the row, saying one of the following > fields is invalid. > > Is this a known bug? Is there a workaround? Shouldn't > repmcli be able to handle this case? > Yes, it is a known 'limitation' ;-) There is a workaround. You could use the RECORDS format for saving the data in a file during export. Your command would look like this DATAEXTRACT FOR DATALOAD TABLE "FORMS" OUTFILE 'path and file name for commands' OUTFILE 'path and file name for data' RECORDS This format is a proprietary SAP DB Loader format. But it saves the data as it is. The formats COMPRESSED and FORMATTED are still limited in this as the server reads line by line from a data file for these formats (as you experienced). Hmm, to run the load use the command created by the loader (you're already an expert in doing this, right ;-)). Let me know if you need some more help to get it run. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
