Access
To display or modify record selections-omissions on an access, do one of the following:
Select the SEL/OM option in the context-sensitive menu (or the equivalent button) in the Accesses tab of the LDM/PDM screen.
Click the SEL/OM button of the Create/Modify an access dialog box.
Important note: The selections-omissions of an access are not taken into account in AS/400 native generation.
Displayed data
Name and description of the logical entity and of the access.
Lists
Select-Omit
List of select-omit expressions of the access.
The item sequence in the list can be modified.
Single-selection list.
S/O (selections/omissions)
Operation to be applied to the property.
Values available:
S |
Selection of records. |
O |
Omission of records. |
" " |
Complement of selection or omission operation. |
Property
Name of the property to which the selection or the omission is applied.
This field is associated with the use of the "COMPARE", "RANGE" and "VALUE" functions.
Function
Function type.
Values available:
ALL. |
COMP (COMPARE.) |
RANGE. |
VALUE. |
Oper. (operator)
Comparison operator, associated with the "COMPARE" function.
Values available:
= |
EQ |
EQUAL |
<> |
NE |
NOT_EQUAL |
< |
LT |
LESS_THAN |
!< |
NL |
NOT_LESS_THAN |
> |
GT |
GREATER_THAN |
!> |
NG |
NOT_GREATER_THAN |
<= |
LE |
LESS_THAN_OR_EQUAL |
>= |
GE |
GREATER_THAN_OR_EQUAL |
Data entry
Value(s)
Value of the properties associated with the selected function.
Syntax:
C function |
A value. |
R function |
A minimum limit and a maximum limit separated by a space. |
V function |
A list of values separated by spaces. |
A function |
No value to specify. |
The values can be constants or properties of the access's specific format.
Alphanumeric constants must be entered between single quotes.
Buttons
Add
This button adds to the selection-omission list, a selection or omission expression defined in the input fields.
Modify
This button replaces the expression selected in the list with the values defined in the input fields.
Delete
This button deletes the selected expression from the list.
Modify (validation)
This button validates the modifications made and closes the dialog box.
Cancel
This button closes the dialog box without validating the modifications made.
Keyboard shortcut: Esc.