Display all Locks (2 of 2)

Continued from previous slide

where a.partnum = b.partnum

and a.owner = c.address

and c.owner = d.address

and a.wtlist = f.address

and d.sid = g.sid

and e.tabname = 'syslcktab'

and e.flags = a.type

and f.sid = h.sid

into temp A;

select *

from A;

Previous slide

Next slide

Back to first slide

View graphic version