The second example you gave worked for me. Thanks Carla !
D. Jeff Bland
z/OS System House Installation and Packaging (zSHIP)
BLAND at IBMUS
bl...@us.ibm.com
http://w3.pok.ibm.com/zos/i95a/
845-435-42108/295-4210
Famous quote: Beauty is in the eye of the beer holder.
From:
Carla
To
I want to delete certain rows from table USER_TBL.
Two tables are involved. USER_TBL and OWNER_TBL.
The entries that match BLAND type in OWNER table and who also have a
matching entry in USER table NAME but only for USER_TBL entries with
places equal to HOME.
DELETE FROM SP.TST_USER_TBL WH
