Re: Change of Lock Mode
>
> Hi Netlanders,
>
> is there an easy way to change the lock mode of an existing database
> without exporting/importing the DB in OnLine?
>
> Any hints are welcome :-)
>
> So long,
> Klaus Brand.
>
> is there an easy way to change the lock mode of an existing database
I am assuming that you are talking about the lock mode of "tables" within
your database. If not I'm off base.
Jack Parker wrote the following simple ace report that does the job.
==========
database pic end
output
report to "altertab.sql"
top margin 0
bottom margin 0
left margin 0
end
Select tabname from systables
where tabid > 99 and tabtype != "S"
end
format
on every row
print "ALTER TABLE ", tabname, " LOCK MODE (ROW);"
end
---------
Mikea