RE: Updating Database files with a CL program

You can also use RUNSQLSTM from a cl program.
---------- Original Text ----------

From: C=US/A=INTERNET/DDA=ID/MIDRANGE-L(a)midrange.com, on 25/09/98 14:41:

On Thursday, September 24, 1998 11:54 PM, David Gibbs 
[SMTP:david@midrange.com] wrote:
> At 10:28 PM 9/24/98 , Don wrote:
> >You can use Cl to read a PF then why not turn around and have SQL (you
> >already have the engine on your system as base code) do the updates??
>
> Unforuatenly, you cannot access SQL from CL directly... you still need a
> HLL langauge.

Well.... you can access SQL from CL programs through the intermediate step 
of QMQRY.  Create a QMQRY source that looks like UPDATE FILEX SET 
FIELDY='NEW VALUE' WHERE FIELDZ=&FIELDZ  Compile it and in your CL program 
do a STRQMQRY ... SETVAR((FIELDZ 'ABC'))  This'll change FIELDY for each 
record where FIELDZ is equal to ABC.  Many other cool things are possible 
with this technique!

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

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