Joins File

The UD6/CMTOOL driver can store the data for one physical table in several files, where each file is named based on some of the fields in the primary key. The UD6/CMTOOL driver can also store related data in the same physical file. The joins configuration file controls this behavior.

Here is an example:

UFORM:ULABEL:ULABEL::.\sources\components.dir\*

UXGROUP:UFORM:ULABEL,UBASE::UFORM

UXFIELD:UFORM:ULABEL,GRP,UBASE::UFORM

UXREGS:U_FORMLIB:U_FORMLIB,U_NAME::UFORM

UCTABLE:U_VLAB!U_TLAB:U_VLAB,U_TLAB::.\sources\*

UCKEY:U_VLAB,U_TLAB:U_TLAB,U_KSEQ::UCTABLE

ULANA:U_VLAB,U_GLAB:U_VLAB,U_GLAB,U_VAR::UCTABLE

UCDTYP:UDTDNAME,UMODELNAME:UDTDNAME,UMODELNAME::.\sources\dtd.dir\*

UCFIELD:U_VLAB,U_TLAB:U_VLAB,U_TLAB,U_FLAB::UCTABLE

UCGROUP:U_GLAB,U_VLAB:U_GLAB,U_VLAB::.\sources\*

UCRELSH:U_GLAB,U_VLAB,U_RGLAB:U_GLAB,U_VLAB,U_RGLAB::.\sources\relationships.dir\*

UCSCH:U_VLAB:U_VLAB::.\sources\schemas.dir\*

USOURCE:USUB!UVAR,ULABEL,ULAN:USUB,UVAR,ULABEL,ULAN::.\sources\globals.dir\*

UAPPL:ULABEL:ULABEL::.\sources\applications.dir\*

UAPLFRM:ULABEL:ULABEL,UFORM::UAPPL

USMENU:UMENU,UVAR,ULAN:UMENU,UVAR,ULAN::.\sources\menus.dir\*

USITEM:UMENU,UVAR,ULAN:UMENU,UVAR,ULAN,UTECHSEQ::USMENU

UGREGS:U_FORMLIB,U_NAME:U_FORMLIB,U_NAME::.\sources\registers.dir\*

Each line specifies the following separated by a single colon ":":
* A table name
* The fields to base the join on separated by commas (",") or by exclamation marks ("!")
* The fields in the primary key separated by commas (",")
* An empty place reserved for future use by March Hare
* Either: The parent table, or The name of the directory to store the joined files.

The fields to base the join on must be:
* In the primary key
* In the same sequence as in the primary key
* No more than four (4)

NOTE:
An exclamation mark ("!") is replaced with a directory separator at run-time, allowing you to place different parts of a single table into different directories (eg: USOURCE). NOT MORE THAN ONE exclamation mark ("!") should be used.