Re: Simplest Way to run SQL in a CL?

["Jim Essinger" <dilbernator@xxxxxxxxx>]

I use one of two ways - create a QMQRY that does an insert then run
STRQMQRY, or use a SQL source member, and RUNSQLSTM command.

Jim

On Thu, Apr 17, 2008 at 2:43 PM, Hatzenbeler, Tim <
thatzenbeler@xxxxxxxxxxxxx> wrote:

> I need to do a very simple 'select distinct' type of SQl, and have the
> results go into an existing pf, what's the simplest way to do this in a CL?
>
> I normally use RPG for SQl, but this particular need doesn't require any
> error checking or logic associated with it.
>
> Thanks, Tim
>
> Think Green! Please do not print this e-mail unless you need to. Thank
> you.
>
>
>
> ------------------------------------------------------------------------------
> This e-mail message, including any attachments, is for the
> sole use of the intended recipient(s) and may contain
> confidential or privileged information.  Any unauthorized
> review, use, disclosure or distribution is prohibited. If
> you are not the intended recipient, please contact the
> sender by reply e-mail and destroy the message.
>
>
>
> ==============================================================================
>
> --
> 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.