Hi Joel, Joël Reungoat [mailto:[EMAIL PROTECTED] wrote: > > Hello, > > "SET MAXERRORCOUNT xx" seems to have no effect in loadercli > input file > (Used Maxdb version : 7.5) > Could somebody tell me if this is a known bug or if I > incorrectly use an option ? > > Here is the sample script that I call with loadercli (without > the option > -E) : > //Folowing command should be to allow to drop myProc without > stopping on > error (but it has no effect !) > SET MAXERRORCOUNT 100 > // > DROP DBPROC mySample > //Folowing command is then to force to stop at first error > SET MAXERRORCOUNT 1 > // > CREATE DBPROC mySample AS > BEGIN > SELECT * FROM domain.dbprocedures; > END; > // > CALL mySample > // > > The script produces following report that mentions the SET > MAXERRORCOUNT > 100 is successfull but it has no effect because it stops at the first > encountered error. It does not when I use the option -E 100 > with loadercli. > Actually the MAXERRORCOUNT is evaluated for Loader commands only. This means this option takes effect only for EXTRACT/LOAD/EXPORT/IMPORT/DATAUPDATE commands at all. SQL commands are not affected by this option. Here the documentation is slightly inaccurate. We will fix this asap. MAXERRORCOUNT means that the Loader accepts up to this count of errors when processing a single Loader command. For instance if you LOAD a table with 1 Mio rows and set MAXERRORCOUNT to 1000 the Loader would stop inserting records into this table when encountering the 1001st error. Actually the -E option does what you want. The Loader can be thought of as a client and a server. The client reads the scripts and sends the commands to the server. So if you'd like to have the Loader don't stop on an error at a command in your script use the -E option. If you'd like to have the Loader accept a certain number of errors when processing a Loader command use the SET MAXERRORCOUNT command.
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]
