Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

SQL_OPTION AUTO_CHANGEID

Starting with version 12.6.1, FairCom products, the ctsrvr.cfg file contains the SQL_OPTION AUTO_CHANGEID setting. This setting automatically causes SQL to add a changeid field to all new tables. This behavior matches the JSON DB API. The changeid field enables you to use optimistic locking in SQL.

When you do not want SQL to add the changeid field to new tables, remove the SQL_OPTION AUTO_CHANGEID setting from the ctsrvr.cfg file.

TOCIndex