XOR-ITEMS

Returns a list comprising all values contained only once in all the items referenced.  A value contained more than once in an item will not be returned.

Syntax

XOR-ITEMS file-specifier {item-list} {(options}

Syntax Elements

file-specifier Specifies a file as defined in General Conventions.

item-list A list of item-ids or an asterisk (*) for all items. Can be omitted if there is an active list from a preceding list-generating command.

Options

I Specifies that case should be ignored when comparing attribute values.

S Specifies that case is significant when comparing attribute values.

Comments

Uniqueness of values in an item can be guaranteed by sorting the list with the NEW-SORT-LIST command and specifying the U option.

Only the first field (value or subvalue) is processed, all the other fields being discarded. The merged list therefore contains only the first field from each attribute.

Case Sensitivity

If neither I nor S is specified, the current data case setting (set with the DATA.CC environment option or the CASE TCL command) is used. See Case Sensitivity for more details.

If both I and S are specified an error message is displayed and no list is generated.

Examples

:XOR-ITEMS SUSPECTS ATHOME ATTIME

42 Items selected.

>SAVE-LIST QLIST

[241] 'QLIST' Cataloged.

All values that appear only once in items ATHOME and ATTIME of file SUSPECTS are now in list QLIST.

:XOR-ITEMS CUSTOMERS LIFE CASUALTY MARINE

73 Items selected.

>SAVE-LIST CALL

[241] 'CALL' Cataloged.

The list in CALL contains all values that were in only one of the items LIFE, CASUALTY, and MARINE in file CUSTOMERS.