RE: Embedded SQL in CL

[Buck Calabro/commsoft<mcalabro@xxxxxxxxxxxx>]

>Actually I want to insert a value into a field in a file 
>inside the CL, but I didn't want to have to call another 
>program(COBOL or RPG) to do it.  I wanted to keep everything 
>inside the CL itself.  Normally I would just write a little 
>program, but I didn't want to create another object just to insert
>a date into a file.  Not to sound ignorant, but is there an easy 
>way to update a file from inside a CL program w/o calling 
>another program?

CL is not meant to do I/O; it is meant to do OS400 level stuff.
I/O is meant for HLL programs.

Having said that, you can still use RUNSQL or some similar
utility (no IBM SQL necessary) to process an SQL statement 
like INSERT INTO MASTER... from within a CL program if you 
absolutely positively had no other alternative, but what is 
preventing you from calling an HLL program or starting a 
ReXX procedure?

Buck Calabro
CommSoft, Albany, NY
mailto:mcalabro@commsoft.net




+---
| 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
+---