Find errors in an SPL routine

When you use CREATE PROCEDURE or CREATE FUNCTION to write an SPL routine with DB-Access, the statement fails when you select Run from the menu, if a syntax error occurs in the body of the routine.

If you are creating the routine in DB-Access, when you choose the Modify option from the menu, the cursor moves to the line that contains the syntax error. You can select Run and Modify again to check subsequent lines.