Local Configuration

The Micro Focus XDBC Local server is configured through a configuration file, mfdbc.cfg. This configuration file is where you define the location of your COBOL data files and system catalog, file case instructions, and other important program functions. You can create several different configuration files for different purposes. Configuration files must reside in your Micro Focus XDBC installation directory, specified by the GENESIS_HOME environment variable. You specify the exact name and path when setting up your DSNs on the client.

In a XDBC Local installation, mfdbc.cfg is the only configuration file that is required.

For mfdbc.cfg, you can use configuration variables from several key areas, as shown below. The DICTSOURCE and FILE_PREFIX variables are required. If you installed Micro Focus XDBC in a non-default directory, you must modify the DICTSOURCE and FILE_PREFIX variables in the client configuration file or generate a new configuration file with the mfgenconf batch or shell script file, which is included in your distribution to make the generation of configuration files easier. This utility takes the format:

mfgenconf [-d directory] [-c catalog] [-p prefix] [-n config_name]


-d   Specifies the directory name to use for the GENESIS_HOME environment variable
-c Specifies an optional directory name to use for the system catalog
-p Specifies a location (path) to your data files
-n Specifies a name for the configuration file that is created

This utility will generate a configuration file for you with default values for the configuration options unless you override them with command-line parameters. Most of the settings are read from a template, sample\mfdbc\mfdbc.in, called from your install directory, so you will be able to use this to customize the generation settings for your site's particular needs.

The table below lists the configuration variables available, along with their defaults and brief descriptions. For complete descriptions, including examples, follow the links.

General Setup Options

Variable Default Description
DICTSOURCE Install directory Location (path) of your system catalog
FILE_PREFIX Install directory Location (path) of your data files
Note: If the value contains space(s), it should be enclosed in quotation marks. If the value can contain multiple directories that contain spaces, the entire entry should be enclosed in quotation marks.
FILE_SUFFIX None Extension of your data files

Advanced Options

Variable Default Description
FILE_CASE Default (Mixed) Indicates the file case of your data files
FILENAME_WILDCARD None Defines multi-company wildcards and their respective substitution characters
IGNORE_OWNER 0 Specifies whether you want the table owner to be included in a listing of tables
INVALID_NUMERIC_DATA Error Indicates how to treat non-numeric data in a numeric field
JULIAN_BASE_DATE 19000101 The base date for Julian date calculation
NULL_ALPHA_READ Null Defines how to read null alphanumeric data
NULL_ALPHA_WRITE Spaces Defines how to write null alphanumeric data
NULL_NUMERIC_READ 0 Defines how to read null numeric data
NULL_NUMERIC_WRITE 0 Defines how to write null numeric data
DATE_ZERO_VALUE YYYYMMDDHHmmsshh (Year/Month/Day/Hour/Minute/Second/Hundredths) When DATETIME = DATE_ZERO_VALUE, LOW-VALUES or all 0 are returned
DATE_NINE_VALUE YYYYMMDDHHmmsshh (Year/Month/Day/Hour/Minute/Second/Hundredths) When DATETIME = DATE_NINE_VALUE, HIGH-VALUES or all 9 are returned
DATE_NULL_VALUE YYYYMMDDHHmmsshh (Year/Month/Day/Hour/Minute/Second/Hundredths) DATETIME is SQL NULL, the value of the DATE_NULL_VALUE will be written to the COBOL data.
DATE_INVALID_VALUE YYYYMMDDHHmmsshh (Year/Month/Day/Hour/Minute/Second/Hundredths) When DATETIME = DATE_INVALID_VALUE, spaces will be written to the COBOL
READ_ONLY No Read/write status of data files

Logging Setup Options

Variable Default Description
DEBUG_LOGFILE None Name and location of the log file used for debugging
DEBUG_LOGLEVEL 0 The log level you desire for debugging

Click here to view a sample configuration file mfdbc.cfg.