Enabling Generation of Joins for an Application

Joins are enabled by placing a statement in a program-specific configuration file.

To enable a join

  1. Open the program-specific configuration file for editing:

    %LAWDIR%\productline|dataarea\xxsrc\xxnnn.cfg

    where the following parameters apply.

    Parameter Description
    productline|dataarea The product line or data area that contains the program you want to enable joins for.
    xxnnn The program code, where xx is the two-letter system code abbreviation, and nnn is the numeric portion of the program code.
  2. Add the following line to the file:

    JOIN=FileName.IndexName(RelationName.0)[; (RelationName.0) ... ]

    where the following parameters apply.

    Parameter Description
    FileName The table you want to enable joins for, as defined in dbdef.
    IndexName The index that is used to access data from the primary file (FileName).
    RelationName The relationship that is used to access data from the joined file as defined in dbdef.