Selections Based on Group Key Values

Some data sources use group keys. A group key is a single key composed of several fields. You can use a group name to refer to group key fields.

To select records based on a group key value, you need to supply the value of each field. The values must be separated by the slash character (/).

Note that a WHERE phrase that refers to a group field cannot be used in conjunction with AND or OR. For related information, see Using Compound Expressions for Record Selection.

Example: Selecting Records Using Group Keys

Suppose that a data source has a group key named PRODNO, which contains three separate fields. The first is stored in alphanumeric format, the second as a packed decimal, and the third as an integer. A screening phrase on this group might be:

WHERE PRODNO EQ 'RS/62/83'