nistbladm, Searchable Columns, and Keysnistbladm and Column Values

When an NIS+ table is created, one or more columns are designated searchable with either the S or the I flags as described in "Specifying Table Columns ". You can use the niscat -o tablename command to display a list of a table's columns and their characteristics.

A table is keyed on its searchable columns. This means that each row in the table must have a unique combination of values in the searchable columns. For example, if a table has one searchable column, each table row must have a unique value in that column, no two rows may contain the same value.

For example, suppose you had a table containing one searchable column named city and a non-searchable column named country. The following rows would all be permitted:

But you could not have two rows like:

If a table a table has multiple searchable columns, it is the combination of values that must be unique. For example, suppose you had a table containing two searchable columns, Lastname, Firstname and a non-searchable column named city. The following rows would all be permitted:

But you could not have two rows like this:

NIS+ commands use the values in the searchable columns to identify specific table rows.