Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

ctsqlbigint - FairCom DB SQL Big Integer Fix Utility

A BIGINT issue on HIGH LOW machines could result in improper values on heterogeneous systems. This utility is designed to detect and correct such issues should they occur. Contact FairCom should you require this utility.

Syntax

ctsqlbigint [-<sect>] [dbname [tblname]]

This utility to be compiled as single user with tranproc and run in the FairCom DB SQL operating directory.

  • <sect> the sector size
  • dbname is specified the engine converts the tables in that database. If dbname is not specified all databases will be converted.
  • tblname only the specified table in the given database is converted.

Running the conversion twice restores records to their original values.

TOCIndex