Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

Specifying Primary Keys from Imported Indexes

A command-line option is available with the FairCom DB SQL Table Import Utility, ctsqlimp to specify a primary key from imported indexes. Use the -m option to specify an imported index of the table to be the primary key. The -m option takes an index name as a parameter. The index name is defined in the ridxnam member of the IFIL resource IIDX structure. Please notice that if ridxnam is not defined, an index name is automatically assigned when the table is added to the FairCom DB SQL system tables. The format of the automatically assigned index name is: tablename_indexnbr where indexnbr is zero for the first index.


ctsqlimp my_table -u ADMIN -p ADMIN -m my_index