Re: locking mode does not show properly
Oscar,
You should get the correct lock level out of dbschema, you can use the
following query also:
select tabname, locklevel
from systables
where tabid > 99
order by tabname
The locklevel will be P for page and R for row.
By default, tables are created with page level locking.
Mark
MarkDenham@aol.com