R: Sql and CRTXXXMOD command

Normal procedure should be:
** CRTSQLCBLI OBJ(OBJNAME) OBJTYPE(*MODULE)  if you need to create an ILE
Module
        ( be careful: module name and Program Id should be the same)
        You must then Link and create PGM: 
        CRTPGM PGM(PGMNAME)  MODULE(*LIBL/YOURSQLMOD OTHSMODU)
or 
** CRTSQLCBLI OBJ(OBJNAME) OBJTYPE(*PGM) if you need an ILE PGM
IN this case you will get an ILE PGM with ONE module only.

Sincerely
Domenico Finucci
Fiditalia , Milano, 02- 4301-2494


-----Messaggio originale-----
Da: Cyndi Bradberry [mailto:CyndiB@IHFA.ORG]
Inviato: venerdì 15 giugno 2001 16.10
A: 'Midrange-L@midrange. com' (E-mail)
Oggetto: 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
+---
+---
| 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
+---