Multiple Database Script

As mentioned earlier, splitting application files into distinct database groups enhances performance of the ODBC Driver. This is easily done with import.exe.

Figure 5-2: Add New Database View over the Customer File

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)

DATABASE CUSTOMER.DB

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

The above illustrates adding a new database view (CUSTOMER.DB) over the Customer file (CUSTMAST.DAT). When this script is passed to import.exe, the data dictionary created contains two databases: FAIRCOM.DB with four data files; and CUSTOMER.DB with one data file. To switch between the databases, change the name specified in the Script Name setting in the ODBC Setup dialog.