|
|
|
After installing FairCom DB Standalone SQL Service, the next step is to make the data ready for SQL access. This step involves importing the data into the format FairCom DB uses for SQL tables. This process uses the ctsqlimp SQL import utility to import the data into a FairCom DB SQL database, which serves as the data dictionary for FairCom DB Standalone SQL Service.
This process does not affect data access from your FairCom DB Multi-User Standalone database and it does not modify your existing data files. This process does, however, require that your data files contain a FairCom DB File Structure (known as IFIL structures) and a FairCom DB File Schema (known as a Dynamic Object Definition Array or DODA) discussed in the Using Existing ISAM Data with FairCom DB SQL section in the FairCom DB SQL Operations Guide. You can determine if your data files have these necessary structures by executing the ctinfo utility included with the FairCom DB Standalone SQL Service package. Simply execute ctinfo over a copy of one of your application data files (typically data files will have a .dat file extension) and read the output from the utility. This utility only reads header information from the data file and reports what it finds. It will tell you if the necessary IFIL and DODA structures are present.
