Locating rows by key

If you use LOCATE TABLESPACE KEY, a number of rows might satisfy the condition. In this case, REPAIR returns only the RIDs of the rows and does not perform any VERIFY, REPLACE, DELETE, or DUMP actions which might be coded in that LOCATE block.

You can use the RID option of LOCATE TABLESPACE to identify a specific row. Examples of the messages that are issued are shown in the following example:

DSNU658I - DSNUCBRL - MULTIPLE RECORDS FOUND WITH SPECIFIED KEY 
DSNU660I - DSNUCBRL - POSSIBLE RID - X00000100B' 
DSNU660I - DSNUCBRL - POSSIBLE RID - X000000C18' 
DSNU660I - DSNUCBRL - POSSIBLE RID - X000000916' 
DSNU660I - DSNUCBRL - POSSIBLE RID - X000000513' 
DSNU650I - DSNUCBRP - DUMP 
DSNU012I   DSNUGBAC - UTILITY EXECUTION TERMINATED,
                      HIGHEST RETURN CODE=8

Multiple-column indexes

The KEY option supports only single-column indexes. The following message is issued if you try to locate a row by using a multiple-column index.

DSNUCBRK - INDEX USED HAS MULTIPLE-FIELD KEY