In DB2/400, if I run this statement: delete from ordvcrec a where not
exists(select * from i$paint b where a.part#=b.i$par t)
Where ORDVCREC is a join logical of physical files ORDVALID and
ORDMASCREC, will the rows being deleted be the "logical" rows from
ORDVCREC only, or could physical rows (records) be wiped out in
ORDVALID or ORDMASCREC?
I am assuming that only logical rows will be deleted from ORDVCREC,
but I am afraid to try it...
Thanks for any and all opinions and answers...