The locking schemes in Adaptive Server provide you with the flexibility to choose the best locking scheme for each table in your application and to adapt the locking scheme for a table if contention or performance requires a change. The tools for specifying locking schemes are:
sp_configure, to specify a server-wide default locking scheme
create table to specify the locking scheme for newly created tables
alter table to change the locking scheme for a table to any other locking scheme
select into to specify the locking scheme for a table created by selecting results from other tables
