Steffen, Are you suggesting that I copy the loadercli.exe file from a newer install, copy to the older system, and then re-run the extract?
Keith -----Original Message----- From: Schildberg, Steffen [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 10:39 AM To: Maxdb Subject: AW: problem using loadercli between 7.5.00.08 and 7.5.00.24 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
