Product Documentation

SQL Reference 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)

Example

call fc_check_file_tran_state();


owner table_name

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

admin custmast

admin custorder

admin ordritem

admin itemmast

TOCIndex