solidDB Help : solidDB reference : SQL: Statements : ALTER TABLE : ALTER TABLE ... SET OPTIMISTIC or PESSIMISTIC
  
ALTER TABLE ... SET OPTIMISTIC or PESSIMISTIC
ALTER TABLE table‑name SET {OPTIMISTIC | PESSIMISTIC}
Access requirements
Database user
Usage
Use the ALTER TABLE ... SET OPTIMISTIC or SET PESSIMISTIC statement to set disk-based tables (D-tables) to optimistic or pessimistic. By default, all D-tables are optimistic. M-tables are always pessimistic. A database-wide default for D-tables can be set with the solid.ini parameter General.Pessimistic, see General section.
Example
ALTER TABLE table1 SET PESSIMISTIC;
Go up to
ALTER TABLE