3.6 Predetermined Join Column (PJC) Definitions

A Predetermined Join Column, or PJC, is a special feature of the LANSA Repository.

Unlike the other types of Repository virtual tables, a PJC is a virtual column whose value is determined by a value or values in another table. (Other Virtual Columns are always based on columns within their own table definition.) PJCs use access routes to determine the table relationships.

The type of operations available to be performed depend on the relationship between the tables as indicated by the number of records expected on the access route definition.

• Virtual columns can also be derived from other virtual columns.

Predetermined Column Definition:

3.6.1 PJC Column 3.6.2 PJC Column Details

3.6.3 PJC Type 3.6.4 PJC Source Column

Also See

Virtual columns are described in Virtual Column Concepts in the Developer's Guide.

Predetermined Join Columns are described in Predetermined Join Column Development in the Developer Guide.