SQL Operations Guide

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 );