Re: SQL delete not in related table

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

Richard ECUYER wrote:
> can do things like:
> > CHGVAR &SQLSTR 'DELETE FROM somefile WHERE somefield = somevalue'
> > ADHOCSQL CMD(&SQLSTR)
> >
> > and it works like a champ.
> hi,
> can't you do the same with runsqlstm cmd ?
> one advantage is that you can enter more than one sql statement.

No, because the 'somevalue' in this case, is a parm not known until runtime.