Previous Topic

Next Topic

Data Dictionary Creation - Import Method

The FairCom Data Dictionary can be created with the FairCom import utility, import.exe using a text-based script with the following layout:

DATABASE d_name


TABLE alias_name1(\path\file1_name1)


TABLE alias_name2(\path\file2_name2)


  • d_name is an arbitrary database name or view over the data files  (i.e., FAIRCOM.DB is the database name used in the tutorial).
  • alias_name1 and alias_name2 are arbitrary names for the data files residing on disk (i.e., CUSTOMERS and ORDERS are sample alias names from the tutorial import script, SAMPLE.TXT).
  • path1 and path2 are either fully qualified paths or relative paths to the current logical drive (i.e., FAIRCOM\ODBC\32bit\SAMPLE from the tutorial import script, SAMPLE.TXT).
  • file_name1 and file_name2 are the actual file names residing on disk (i.e., CUSTMAST.DAT and CUSTORDR.DAT from SAMPLE.TXT).
The following example shows one database view (FAIRCOM.DB) and four file members (CUSTOMERS, ORDERS. ORDER_DETAIL, and ITEMS):


DATABASE FAIRCOM.DB




TABLE  CUSTOMERS(c:\FAIRCOM\ODBC\32bit\sample\CUSTMAST.DAT)


TABLE  ORDERS(c:\FAIRCOM\ODBC\32bit\sample\CUSTORDR.DAT)


TABLE  ORDER_DETAIL(c:\FAIRCOM\ODBC\32bit\sample\ORDRITEM.DAT)


TABLE  ITEMS(c:\FAIRCOM\ODBC\32bit\sample\ITEMMAST.DAT)