Documentation to create Joined Logical file is missing

Products

• CA 2E

Issue/Introduction

I am not able to create a joined logical file in a Synon/2E model. I downloaded the instruction from the link provided https://support.broadcom.com/web/ecx/solutiondetails?aparNo=CQ062843&os=AS400, but the instructions have been removed.

Environment

Release : 8.7

Cause

This functionality has been consolidated into the techdocs (see the resolution section below for the document) and the "Create a join file" procedure can be achieved by creating  Virtual Fields.

Resolution

The instruction for virtual fields can be located here: https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-2e/8-7/tutorial/data-modeling/virtual-fields.html

For example, to include the name of the horse when displaying the RACE ENTRY file, specify the Horse name as a virtual field on the RACE ENTRY file. As a result, the Horse name is physically present on the HORSE file, and is logically, but not physically, present on the RACE ENTRY file. This is shown in italics in the following figure.

Additional Information

Please make sure you are accessing the model using *DSNR mode since creating Virtual Fields is a database creation function. Also, if the model file is in use by other users, the process can cause File locks. Perform the SHIFT + F10 on the "EDIT DATABASE RELATIONS" screen and this takes you to the "DISPLAY FILE LOCKS" screen. Review the Job and user details that are locking the file and request the identified user to exit the model and then try to use the file.