7.67.1 GROUP_BY Parameters

FIELDS

NAME

NAME

Specifies the name by which the group of fields is to be known. The name specified must start with a # (like field names) and must not be the same as any field defined in this function or the LANSA data dictionary. Start the name of the group with the prefix "#XG_" if the group is to be an expandable group. For more details about these special types of groups, refer to Expandable Groups.

FIELDS

Specifies the field(s) that are to be in this group. Optionally the field names can be accompanied by field attributes. Refer to Formats, Values and Codes for further information about specifying field names and field attributes.

The following special values may only be used in expandable groups:

• Expandable group name, in the field list, causes the fields assembled under the group name entry to be expanded and included in the field list instead of the group itself.

• *EXCLUDING in the field list causes the field(s) following this special value to be excluded (if present) from the field list. That is, the field list is switched to exclusion mode.

• *INCLUDING in the field list causes the field to return to inclusion mode. This is required if additional fields need to be added to the field list after an *EXCLUDING entry earlier in the list caused the list to be in exclusion mode.