Re: SQL Delete with JOIN

A minor correction...

It's impossible to "delete SQL" from the system...as it's built into the DB.

You may not have had the STRSQL command, or the ability to compile
SQLRPGLE...but believe me, the system could still do SQL.

Actually, I'd be willing to bet money that there were one or two ways for
you to run SQL yourself.

Charles


On Fri, Dec 14, 2012 at 12:42 PM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

SQL was itself deleted from our AS400 until around 8 years ago. The
boss refused to let anyone use it!
I use Charle's tip all the time. The number of times I did a DELETE
and then realise, "oh yeah, there was one other criteria I should have
put"

2012/12/14 Glenn Gundermann <ggundermann@xxxxxx>:

Thanks Charles and Gary.
I really appreciate your replies!

Glenn :-)

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