AW: problem using loadercli between 7.5.00.08 and 7.5.00.24

Hi Keith,

Keith [mailto:keith@xxxxxxxxxxxxxxxxx] 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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx