RE: RPG Stored Procedure, Please Help...

>1) Pass in 2 paramaters,  year, and month.
>2) Check a table with the where clause for year and month,
>3) Lock the row,
>4) Read a field,  update the field buy one, write
>   the row back, and release the row, form its lock.
>5) And pass the new field (the one incremented)
>   back to the calling sql.

OK, first things first.  Write an RPG program to perform these steps.
Disregard the SQL aspect of things for the moment.  Test it by calling it
from a CL program.  Once that works, you're ready to turn it into a stored
procedure.

On iSeries, we can take a program written in any language and turn it into a
stored procedure.  The SQL statement to do that is CREATE PROCEDURE.  Check
both the FAQ and the DB2 references on the Information Centre web site.
Basically, this is nothing more than 'registering' your program and its
parameters so that DB2 knows about it.

When the SP is created, you invoke it with the SQL statement CALL.

  --buck