Before your files can be accessed through one of the SQL APIs, the data must be made ready using a simple import process. This import process reads the File (IFIL structures) and Field (Data Object Definition Array – DODA) schema information and creates the SQL dictionary.
Shut down all instances of your FairCom DB application to ensure your application data files are all in a closed state.
Be sure the FairCom DB Standalone SQL Service is running (the service name is FairCom-SQL; the process name is faircom_sql_service.exe).
Identify your database name. By default, FairCom DB Standalone SQL Service (faircom_sql_service.exe) creates a database called "ctreeSQL." This can be changed in the ctsrvr.cfg file located by default in the data directory. See the SQL_DATABASE keyword. Note you will need to stop and restart the faircom_sql_service* process after any changes to ctsrvr.cfg.
Use the ctsqlimp utility to import your data into the database. A typical usage might look like this:
ctsqlimp.exe \mypath\myfile.dat –d ctreeSQL -u USERNAME -a PASSWORD
