3.6.4 PJC Source Column

Mandatory.

The source column in the 3.5.3 Accessed Table that is to be used with the operation specified by the 3.6.3 PJC Type.
No check is made on the Predetermined Join Column's suitability to hold the required information.

Rules

• Column must exist in the nominated 3.5.3 Accessed Table of the access route.
• Column type must be numeric if the 3.6.3 PJC Type is Total, Maximum, Minimum, Average.

Tips & Techniques

• It is your responsibility to check that the 3.6.1 PJC Column is suitable to hold the required information.

Also See

3.6.1 PJC Column
Access Route Definitions