Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

Automatic Database Conversion Options

Enhancements and features to FairCom DB SQL sometimes require changes to the base system tables and internal workings of the FairCom DB SQL engine. To make this transition as seamless as possible, an automatic verification and conversion to the new format takes place when the server detects system tables from a previous version of the FairCom DB SQL.

To prevent this activity from occurring, a new FairCom DB SQL configuration keyword was introduced.

SQL_OPTION NO_DB_CONVERSION

This server configuration keyword is used to instruct the FairCom DB SQL to not perform the verification and the conversion process. To prevent a failed conversion attempt, these steps are controlled within a transaction such that upon failure a transaction abort or automatic recovery will restore the original data.

Refer to the Appendix Configuration Keywords for a complete list of FairCom DB SQL specific keywords.

TOCIndex