RE: loadercli shows *no line numbers* for syntax error messages i n dbprocs
"Schildberg, Steffen" <[email protected]>
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
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 -- Steffen Schildberg SAP DB Team SAP Labs Berlin