I am trying to create a stored procedure in Toad for data analysis on a ibm iseries DB2 platform. I am getting the following error
ERROR  [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0199 - Keyword END not expected. Valid tokens: FOR WITH FETCH ORDER UNION EXCEPT OPTIMIZE.
It is a very simple stored procedure
CREATE PROCEDURE APAGING()
Select * from m3djdtst.CMNDIV
Fetch first 5 rows only
I have also tried adding a @ after the end and still no luck.