We just recently got an iSeries V5R2. I am trying to create a SQL stored procedure on this darn thing. I have successfully created a couple of procedures that update files. However, when I try to create a stored procedure with a simple select statement, I get an error message saying the procedure did not compile. I looked at the message and it says "Position 10 INTO clause missing from embedded statement". Here is the SQL statement:
Apparently I have NO idea what I am doing on this thing. Shouldn't that statement work?? Thanks for any help!