Table References (tltsm0110m000)
Use this session to view references between tables and to modify soft references.
In general, this session provides the information to answer the question If this table is shared, which tables must be shared as well?.
The session displays both hard references and soft references. You cannot modify hard references in this session.
To view all the tables that refer to a certain table, select a record and click on the menu.
To view the references in a diagram, select a record and click on the menu.
Package combination
The session displays only the references that exist in the package combination you selected. By default, the package combination of the user is selected.
To select another package combination, click on the menu. You must choose one of the package combinations entered in the Table Sharing Package Combinations (tltsm0105m000) session.
Hard references
To update hard references, use the Update Table References (tltsm0201m000) session.
Soft references
In this session, you can add, modify, or delete a soft reference. You can also set a soft reference to expired. In that case, the soft reference remains active in older VRCs.
Package VRC
You can create or modify soft references which are contained in a program script in the current package VRC.
To change your current package VRC, click on the menu.
If you enter a soft reference, LN determines the VRCs of the referral table and the reference table based upon the package combination that you selected.
- Package From
-
The package of the referral table.
- Package From
-
The description of the package.
- Module From
-
The module of the referral table.
- Module From
-
The description of the module.
- Table From
-
The code of the referral table.
- Table From
-
The description of the table.
- Field From
-
The field that has a reference.
- Field From
-
The description of the field.
- VRC
-
The Version part of the referral table 's VRC.
- VRC
-
The Release part of the referral table 's VRC.
- VRC
-
The Customer part of the referral table 's VRC.
- Package To
-
The package of the reference table.
- Package To
-
The description of the package.
- Module To
-
The module of the reference table.
- Module To
-
The description of the module.
- Table To
-
The code of the reference table.
- Table To
-
The description of the table.
- VRC
-
The Version part of the reference table 's VRC.
- VRC
-
The Release part of the reference table 's VRC.
- VRC
-
The Customer part of the reference table 's VRC.
- Mode
-
The reference mode.
If a table field is defined with a reference, the table field can have a reference mode.
Allowed values
- Mandatory
-
The table field must contain a value that is present in the reference table.
- Mandatory unless empty
-
The table field can be empty. If the table field is filled, its value must be present in the reference table.
- Non Mandatory
-
The table field can contain a value that is present in the reference table, but the table field can also contain an other value.
- Type
-
The Reference Type determines whether the reference is a hard reference or a soft reference.
- Package Program Script
-
The package code of the program script that contains the soft reference.
- Package Program Script
-
The description of the package.
- Module Program Script
-
The module code of the program script that contains the soft reference.
- Module Program Script
-
The description of the module.
- Code Program Script
-
The program script that contains the soft reference.
- Code Program Script
-
The description of the program script
- VRC
-
The Version part of the program script 's VRC.
- VRC
-
The Release part of the program script 's VRC.
- VRC
-
The Customer part of the program script 's VRC.
- Script Type
-
The value of the Program Script Type field of the program script.
- Expired
-
If this check box is selected, the reference has been set to expired.
Note: Only soft references can be set to expired.