Two questions : if loadercli is not an SQL tool, which tool should I be using (on linux) to devellop my stored procs ?
I just need some tool to take a file filled with stored procs run it, and give me a line number for the syntax errors.
loadercli seems to be the closest to this, but would it make more sense to 'enhance' ireport.py to 'feed' from files ?
Please tell me, and I'll go agead and implement it, also by looking at loadercli's source, it wasn't immediately clear where the best place would be to add this, so a hint on this would be helpfull.
Thanks
Schildberg, Steffen wrote:
Hi MAX,
MAX [mailto:[EMAIL PROTECTED] wrote:
Subject: loadercli shows *no line numbers* for syntax error messages in dbprocs
It erpors messages like :
Error position : 2801
as if the dbproc was a single line string...
Of course one would expect line number *AND* character position number,
but whoever wrote loadercli, or loadercli's parser thought otherwise.
Nope, he did not. See below.
To debug a procedure I had to put it all on a single line to no what the actial "error position" was... This is mindbogling...
It is indeed.
Please tell me there's a way to add this "functionnality" !
That's easy. You only need to modify the kernel itself. The loader simply 'routes' SQL commands to the kernel without parsing them at all (it is definitely not an SQL tool as already stated here in the group). So the error message comes directly from the kernel.
Regards, Steffen
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
