Re: SQL delete not in related table

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

You can't do things on the fly with RUNSQLSTM - it is based on a source 
member. You need to modify it first, which RPG could do with the statement 
you pass in. Maybe this utility does this, and you could probably pass in 
multiple statements simply by using the semi-colon separator you need to 
use, anyway.

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.