Re: Can I run an SQL statement inside a CL?

From: Dave Odom

As your article points out, you have STDIN and the same for out, but I
found I needed to go further. I needed to read and write to multiple
files and found that by using SQL I could talk to many more tables than
the STDIN would allow. Don't get me wrong, STDIN and out are a good
place to start.

I usually only use STDIN for input parameters. I, too, like SQL; I think
the article did a pretty good job of using SQL, actually. First a DSPFD
to
an output file, then SQL to access the file, and finally a call to the
appropriate compile command, and voila, a poor man's mass compile
procedure!

Have you ever tried to address a formatted screen, either 5250 or GUI

from

REXX? That sort of function is built in to VM and MVS REXX with calls

to

XEDIT screens. But I have not found that in the i5 version.

Nope, never got around to that, but as Tom points out you could probably
use
UIM. Not that I'd wish that on anyone <grin>. But I don't much like
SNDRCVF in CL either. If I need a display file, I usually call an RPG
program. For me it's a better tool for that particular job.

Joe

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Joe,