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)
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.
|$Revision: 1.11 $ $Date: 2011/02/28 02:56:33 $||[go to top]|