Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

fc_set_file_tran_state( )

Sets the FairCom DB transaction mode for a table.

WARNING: Do not set this value without a complete understanding of c-tree transaction control. There is great potential for data loss if not properly set.

Parameters (3)

owner VARCHAR(64)

table_name VARCHAR(64)

mode TINYINT

Valid modes:

  • 0 No transaction control.
  • 1 Transaction control without recoverability. (ctPREIMG)
  • 2 Transaction control and recoverability. (ctTRNLOG)

Example

call fc_set_file_tran_state( 'admin', 'custmast', 0 );

TOCIndex