Description

The refint tool checks the integrity of references in the database. You can also use it to repair the integrity of a corrupted database. Integrity refers to the accuracy or validity of data.

You can use these options:

  • –u/U

    Print usage information.

  • –v/V

    Print version information.

  • –p package combination

    The name of the package combination that is to be used.

  • –C compnr

    Specify the company number.

  • –c

    Check validity of references with the Report Only option. Undefined references to the specified tables are logged in the ref_undefined file.

  • –r

    Check validity of references and repair reference counters. From all specified tables, the reference counters are checked and changed if required. Handled undefined references to the specified tables are logged in the ref_undefined file.

  • –l/-L file

    Creates a file that contains all undefined references. If you use the option –l, the name of this file will be ref_undefined. With the option –L, you can specify your own file name.

  • –I file

    Check or repair all tables whose name appears in the file file. Each table name in file must be on a separate line. A table name might include a company number. For example, table tccom100 in company 570 is specified as tccom100570.

    The -F option of bdbreconfig can produce such files.

  • –N table

    The name of the table whose references must be checked or repaired. The table name might include a company number. For example, you can specify –N ttadv100 or –N ttadv100999.

  • –s

    Handle specified tables only.

Examples

refint –Iref_tables –c –C100
refint –Ntimcs016 –l