Re: SQL delete not in related table

I don't know, have not used this technique - see my other post.

Vern

At 08:35 AM 6/18/2005, you wrote:

hi,
can't you do the same with runsqlstm cmd ?
one advantage is that you can enter more than one sql statement.

----- Original Message -----
From: "Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Saturday, June 18, 2005 3:19 PM
Subject: RE: SQL delete not in related table


> > While waiting on the book, go to InfoCenter
>
> Thanks.  I already have (had) the manuals downloaded to my PC.  Some of
the
> other links are new, though.
>
> Late Friday afternoon, I had a situation where I needed to pass a parm
into
> the RUNSQLSTM member, which you can't do.  I found, on the iseriesnetwork
> site, an SQL command, CL, and RPG program designed to do this.  From 1998
I
> believe.  Renamed it ADHOCSQL so I would remember it wasn't from IBM.  Now
I
> can do things like:
>
> CHGVAR &SQLSTR 'DELETE FROM somefile WHERE somefield = somevalue'
> ADHOCSQL CMD(&SQLSTR)
>
> and it works like a champ.
>
> --
> Jeff Crosby
> jlcrosby@xxxxxxxxxxxxxxxx
> Opinions expressed are mine only and not necessarily the views of my
> company.  Unless I say so.
>
>
>
> --
> 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.
>
>

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