Product Documentation

Database Integrity Utilities

Previous Topic

Next Topic

ctfixbin - Fixing Affected Tables

Based on the output of the ctchkbin utility, execute the ctfixbin utility on a particular table to set the binflag property of CT_ARRAY and CT_2STRING fields to the appropriate value.

Operational Model:

  • Standalone

Usage:

ctfixbin.exe table_name action [-s server] [-u username] [-a password] [-d database]

  • table_name is the name of a table to fix (without the .dat extension)
  • action is one of the following:
    • 1 - set binflag to CTDB_BINARY_UNKNOWN
    • 2 - set binflag to CTDB_BINARY_WITHOUT_LENGTH
    • 3 - set binflag to CTDB_BINARY_WITH_LENGTH
  • -d database - Scan database. Default is ctreeSQL
  • -s server - Default is FAIRCOMS
  • -u username - Default is ADMIN
  • -a password - Default is ADMIN

Example

ctfixbin.exe admin_tb13 2 -s FAIRCOMS -d ctreeSQL -u ADMIN -a ADMIN

TOCIndex