Chapter 3 DBMS Reference Guide

DefineJoin

Defines a join for a reference, this corresponds to the %JOINS% variable. This is another way of defining the contents of the create reference statement.

Usually the create script for a reference uses the variable %CKEYCOLUMNS% and %PKEYCOLUMNS% which contains the list of Child and parent columns separated by comma.

If you use %JOINS%, you can refer to each paired parent and child columns separately.

When using %JOINS%, a loop is executed on Join for each paired parent and child columns, allowing to have a syntax mix of PK and FK.

Example

In Microsoft Access:

DefineJoin = P=%PK% F=FK%
Create = CreateJoin C=%CONSTANME% T=%TABLE% P=%PARENT%
(
%JOINS%
)

Copyright (C) 2005. Sybase Inc. All rights reserved.