Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

Importing Tables Into FairCom DB SQL

Before you can access data and index files created by an ISAM application with FairCom DB SQL, you need to import the data into FairCom DB SQL. For this purpose, FairCom has created the FairCom DB SQL Import Utility, ctsqlimp.

ctsqlimp - FairCom DB SQL Import Utility


As we import a table into FairCom DB SQL, the utility reads the field definitions from the table’s DODA and populates FairCom DB SQL system catalog tables. We cannot allow the import utility to import the MYTIME fields as CT_INT4 field types. We have to make sure the import utility will import the MYTIME fields as CT_TIMES fields (equivalent to FairCom DB SQL TIMESTAMP field type).