Setup Files

SQL.INI and CONFIG.TPM are two setup files used by DDBuilder to keep track of data source information.

SQL.INI File

SQL.INI is an ASCII text file that identifies the native BASIS data sources that are available to the BASIS SQL Engine. The file lists the name and configuration file path for each data source. The following example of an SQL.INI file identifies the Chile Company and Class Reunion data sources, as well as the respective paths to their CONFIG.TPM configuration files:

[BASIS Data Sources]
Chile Company
Class Reunion
[Chile Company]
CONFIG=c:/basis/ddbuild/examples/chile/CONFIG.TPM
[Class Reunion]
CONFIG=c:/basis/ddbuild/examples/reunion/CONFIG.TPM

Either forward slashes (/) or back slashes (\) can be used to designate the directory paths.

File Location

The SQL.INI file must be installed in the BASIS home directory and must be listed in the win.ini file, as follows:

[BASIS]
home=path_to_BASIS_directory

CONFIG.TPM File

CONFIG.TPM is an ASCII text file that identifies the location of the bbdict and data directories, which are used to store the source data, and file structure data, respectively. The following example of a CONFIG.TPM file identifies the paths to the Chile Company bbdict and data directories:

# Chile Company Data Source Configuration
DICTIONARY=c:\basis\ddbuild\examples\ chile \bbdict\
DATA=c:\basis\ddbuild\examples\ chile \data\

Either forward slashes (/) or back slashes (\) can be used to designate the directory paths. DDBuilder recognizes a line that starts with the "#" character as a comment.

Global Paths

Adding global paths to the CONFIG.TPM files makes it easier to update them paths to accommodate directory structure changes. The following illustrates possible global path definitions for the preceding CONFIG.TPM file:

# Taos Demo Database Configuration
PROJECT=c:\basis\ddbuild\examples\taosdemo\
DICTIONARY=(PROJECT)bbdict\
DATA=(PROJECT)data\

Data Server Login

To use DDBuilder with the PRO/5 Data Server, provide user login information by adding the following line to the CONFIG.TPM file:

USERID=loginname