Sql and CRTXXXMOD command

I have used the template in the Sorcerer's Guide to create socket programs
to interface with our Web Server on NT/IIS.  I would now like to add another
function using embeded SQL, but I can't seem to find the correct combination
of CRTXXXMOD and CRTPGM to do this.  I am a complete SQL newbie. We added it
to our box last month, I have several books, but am getting lost.  I also
tried to put my function into a service program (ala Sorcerer's guide) so
that all my sockets could access it, but again, I couldn't figure out which
commands to use to create the program.  Is this were stored procedures come
in ?  My function is simple. I get a RRN from one file and increment it.
Using that as a key, I write a record to another file, logging the action
taken in the first program. We do this with another web system, but not with
SQL. I was trying to modernize things.  
If it matters, I am a V4R4; current on PTF's.
Thanks for any directions to manuals.

Cyndi B.
Boise, ID
 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---