You are here: Job and Form Set Rules Reference > JDT Rules Reference > MultipleDataDictionaryFiles

MultipleDataDictionaryFiles

Use this form set level rule to specify multiple data dictionaries (XDBs) to use across multiple Key1/Key2 combinations. You can specify which item (Key1, Key2) or combination of items determines the switch. If the database is not found in the list of possibilities, the system loads the default XDB, as specified by the original INI option.

Syntax

;MultipleDataDictionaryFiles;2;parameters;

You specify the parameters based on which key tells the system when to switch from one data dictionary to another. You can use the keys individually or in any combination.

Example

Here are some examples:

Example	This tells the system to switch XDBs
;MultipleDataDictionaryFiles;2;Key2;	Based on the Key2 field
;MultipleDataDictionaryFiles;2;Key1,Key2;	Based on the Key1, Key2 combination

You specify XDB files using the MultiDataDict control group. For each XDB file, use an INI option similar to the one shown here:

< MultiDataDict >

File = FileName;IDFormat

Option	Description

File	For FileName, include the full file name and path followed by a semicolon. The IDFormat is based on the parameters you supplied to the rule. Note: In the first example below, the IDFormat would be Key2Value, for the second example, it would be Key1Value;Key2Value.

Option

Description

File

For FileName, include the full file name and path followed by a semicolon. The IDFormat is based on the parameters you supplied to the rule.

Note: In the first example below, the IDFormat would be Key2Value, for the second example, it would be Key1Value;Key2Value.

Based on the first example, assume Key2 has these possible values:

CAR, BOAT, and MISC

with corresponding XDBs of:

CARXDB.DBF, BOATXDB.DBF, and MISCXDB.DBF

The AFGJOB.DAT file would contain:

;MultipleDataDictionaryFiles;2;Key2;

The INI file would contain:

< MultiDataDict >

File = CARXDB.DBF;CAR

File = BOATXDB.DBF;BOAT

File = MISCXDB.DBF;MISC

Thus whenever the Key2 ID changed to one of these values, the appropriate XDB would be loaded.

Based on the second example, assume Key1 has these possible values:

LIFE and VEHICLE

Assume Key2 has these possible values:

Under the VEHICLE Key1	CAR, BOAT, MISC
Under the LIFE Key1	SINGLE, MARRIED

The AFGJOB.DAT file would contain:

;MultipleDataDictionaryFiles;2;Key1,Key2;

The INI file would contain:

< MultiDataDict >

File = CARXDB.DBF;VEHICLE;CAR

File = BOATXDB.DBF;VEHICLE;BOAT

File = MISCXDB.DBF;VEHICLE;MISC

File = SINGXDB.DBF;LIFE;SINGLE

File = MARRXDB.DBF;LIFE;MARRIED

Whenever the Key1 and Key2 combination changed to one of these values, the system would load the appropriate XDB.

Open table of contents