Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

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)


call fc_check_file_tran_state();

owner table_name

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

admin custmast

admin custorder

admin ordritem

admin itemmast