Hi Keith, Keith [mailto:[EMAIL PROTECTED] wrote: > > I extracted a table and schema from a 7.5.00.08 db instance with: > > DATAEXTRACT FOR DATALOAD TABLE bom_ext OUTSTREAM 'bomext.cmd' > OUTSTREAM 'bomext.dat' > > I copied the file to the new server running a 7.5.00.24 > instance and ran: > > loadercli -u USER,MYPASSWD -d SYM -b bomext.cmd > > > The create portion of the script ran fine but I got the > following error during the dataload portion: > > > This value is not a valid number: > > Any suggestions? > Loader of version 7.5.00.19 and higher use a true CSV reader. Earlier implementations did use pattern matching and requested either all data included in delimiters or none at all. And earlier implementations did not necessarily escape delimiters during extract if those were found in the data itself. I'm pretty sure there is a record that has data with not escaped delimiters in the data.
I'd suggest to extract the data with the newer Loader of version 7.5.00.24. Is this possible for you? Sorry for any inconvenience. Regards, Steffen -- Steffen Schildberg MaxDB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
