Re: Change of Lock Mode
Klaus Brand writes:
>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.
A simple way is the following shell script:
#---------------------------- trim here ---------------------------------#
dbaccess dbname - - <<!!! | grep "ALTER TABLE" | dbaccess dbname - -
SELECT "ALTER TABLE " || tabname || " LOCK MODE (ROW);" FROM systables;
!!!
# Note: double pipe "||" means concatenation of strings in SQL
#---------------------------- trim here ---------------------------------#
Hope this help,
Mario R. Canto
Santa Fe, Argentina.
tconsex@ceride.BITNET
tconsex@arcride.edu.ar.UUCP