7.108.1 SELECTLIST Parameters
Specifies the name of the list that is to be processed by the SELECTLIST / ENDSELECT loop.
The default value of *FIRST specifies that the first list declared in the RDML program by a DEF_LIST (define list) command is the list to be used (which may be a browse or a working list).
If a list name is used then the list name must be declared elsewhere in the RDML program by a DEF_LIST (define list) command.
Specifies which entries from the list are to be processed by the SELECTLIST / ENDSELECT loop.
*ALL, which is the default value, indicates that all entries in the list should be processed by the loop. When the list being processed is a working list this is the parameter value that is valid.
*SELECT indicates that only entries that have a non-blank "select" field should be processed by the loop. A "select" field in a list has the field attribute *SELECT associated with it. For more details, refer to the DEF_LIST command. Also see how field attributes are used.
*ALTERED indicates that only entries that have been altered since they were added to the list by the ADD_ENTRY or INZ_LIST command should be processed by the loop.
*NOTNULL indicates that only entries that have a non "null" value in one or more of the fields should be processed by the loop. The "null" value is blanks for alphanumeric fields and zero for numeric fields.
*DISPLAY indicates that only entries that were added or updated in the list when the screen processing mode was *DISPLAY should be processed by the loop. For more details, refer to Screen Modes and Mode Sensitive Commands.
*ADD indicates that only entries that were added or updated in the list when the screen processing mode was *ADD should be processed by the loop. For more details, refer to Screen Modes and Mode Sensitive Commands.
*CHANGE indicates that only entries that were added or updated in the list when the screen processing mode was *CHANGE should be processed by the loop. For more details, refer to Screen Modes and Mode Sensitive Commands.
*DELETE indicates that only entries that were added or updated in the list when the screen processing mode was *DELETE should be processed by the loop. For more details, refer to Screen Modes and Mode Sensitive Commands.
Values may not be as expected on exit from a selectlist loop due to an extra record being read to determine when to terminate the selectlist loop.
For more information, refer to the Specifying Conditions and Expressions which describes how to specify conditions and expressions.
The WHERE parameter is valid only for working lists. If the WHERE parameter is not specified, all entries in the working list are returned.
After a SELECTLIST/ENDSELECT loop utilizing a where condition, the contents of the fields are unpredictable. The entries matching the where condition should only be processed within the SELECTLIST/ENDSELECT loop.