RE: RPG Stored Procedure, Please Help...

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Thank you... I will do some google searches... and see what I come up with
for the Call command...

I'm sure i'll need more help...

tim

> -----Original Message-----
> From: Buck Calabro [SMTP:Buck.Calabro@commsoft.net]
> Sent: Wednesday, December 18, 2002 8:41 AM
> To:   rpg400-l@midrange.com
> Subject:      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
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.