RE: Sql and CRTXXXMOD command

["Phil" <sublime78ska@xxxxxxxxx>]

CRTSQLRPGI is for both modules and programs.  One of the keywords on the
command allows you to select which one.

Phil

-----Original Message-----
From: owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]On
Behalf Of Cyndi Bradberry
Sent: Friday, June 15, 2001 10:10 AM
To: 'Midrange-L@midrange. com' (E-mail)
Subject: 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
+---


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
+---