SQL Reference Guide

fc_check_file_tran_state( )

Returns the current FairCom DB transaction mode for the specified table.

Result Set Fields (2)

owner VARCHAR(64)

table VARCHAR(64)

Returned modes:

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

Example

call fc_check_file_tran_state();

owner table_name

----- ----------

admin custmast

admin custorder

admin ordritem

admin itemmast