Oh I just read it again and you meant using FORMATTED for extracting and FORMATTED BINARY for loading ? I thought FORMATTED BINARY would expect some sort of HEX format, but the only difference is how it reads the data file? That could have saved me some work....
Since my way seems to work right now I'll try that first...the advantage seems to be that COMPRESSED data files with HEX columns are in average still smaller than FORMATTED files. ----- Original Message ----- From: "Schildberg, Steffen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 10:46 AM Subject: RE: LF in VARCHAR column confuses loadercli > 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 > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
