RE: LF in VARCHAR column confuses loadercli
"Schildberg, Steffen" <[email protected]>
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
Hi Marco, Watz [mailto:[email protected]] wrote: > Subject: Re: LF in VARCHAR column confuses loadercli > > Ok looks like I found a solution that might work, though it > requires me to do alot more parsing. > Adding the HEX keyword behind each CHAR field in the field > list of DATAEXTRACT/DATALOAD should do the job, at least > according to the docs. > As you wrote you're using FORMATTED data files. So a slight and moderate modification could be to use FORMATTED BINARY instead of FORMATTED for loading. In this case the Loader reads row length bytes for every record and not line by line. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin