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.