Hi Jason, Jason T Marcotte [mailto:[EMAIL PROTECTED] wrote:
> Subject: Carriage Returns Ignored in Dataload > > I'm having difficulty loading character fields with carriage > returns with loadercli. My control file looks something like... > Well, yes, what should I say: it's a known issue and on our list but still not solved - I'm terribly sorry. We thought it not that important. But as you're not the first requesting this we'll put it on the head of the list of issues to be done asap. To find a workaround I'd like to ask you first how you generated the data to be loaded - using the loader and DATAEXTRACT? If so there is a format called RECORDS. This is a proprietary SAP DB Loader format and thus rather not readable (length information, simple data and long data in one data file). Using this format the Loader does simple mass inserts (upon DATALOAD) as with the other formats COMPRESSED and FORMATTED. The only difference is that using this format we eliminated some shortcomings as there are: - the newline problem - separator-in-data-problem - NULL value representation (is indicated by a special length value) ... All other infile specs (DATE format, ...) remain valid. The only problem with this format is that it is a proprietary SAP DB format. If you got your data from another dbms or generated it with some editor the only workaround would really be to use FORMATTED BINARY. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
