Re: Updating Database files with a CL program

[Rob Berendt <rob@xxxxxxxxx>]

Ravi,

RUNSQL is a function that came out of a magazine.  We got ours from News/400.
Midrange computing had a similar article.  The run from News/400 uses QMQRY.
It is not required that you have QMQRY on your system.  You can still use the 
commands:  STRQMQRY, CRTQMQRY without it.  The actual product QMQRY
just gives you a prompted interface which is a hybrid of WRKQRY and STRSQL.
I use RUNSQL extensively.  It has one minor truncation bug that only 
sporadically
hits.  The bug runs something like
INSERT INTO lib/file SET column = 'Now is the time for all good men to come to 
the
aid of their country.'
May get turned into:
Column
------
Now is the time for all goodmen to come to the aid of their country.





ravi@spacestar.com on 09/24/98 12:04:20 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Subject:        Re: Updating Database files with a CL program

You can use RUNSQL in a CL program

Stephen Johnson wrote:
> 
> Hello,
>  I am just curious if someone can answer a stupid question for me.  I
> need to update a Database Feild and want to know if I can do that with OPNQRYF
> in a CL or if I will have to code it in COBOL to access the Database.  Thanks
> 
> --
> Stephen Johnson
> * Unite For Java -- http://www.javalobby.org *
> Performance Technologies
> IBM
> 3605 Hwy 52 N
> Rochester MN 55901
> Phone : (507) 253-6822
> Fax :  (507)253-7743
> Stephen Johnson/Rochester/Contr/IBM
> Internet - v2cib216@us.ibm.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
> +---
+---
| 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
+---