Category 4: All Other User Commands

DCCTFPR performs a hashing search to determine whether a hashing entry exists for the table named in the Request Area.

Class A: No Hashing Entry

DCCTFPR returns to DCCTPPR and a return code 05(001) is given to the application.

Class B: Hashing Entry Found

If it finds an entry, DCCTFPR checks to see if the system generation options specify skipping closed URTs (see SKIPURT=).

If SKIPURT=YES and the URT is closed, DCCTFPR looks for the next hashing entry (if any) and repeats the procedure from the beginning for this class.
If the URT is open or if SKIPURT=NO, DCCTFPR compares the table name in the hashing entry to the table name in the Request Area.

Case 1:

Table Names Do Not Match

DCCTFPR looks for another hashing table entry and repeats the logic from the beginning of this section.

Case 2:

Table Names Match

DCCTFPR checks whether SYNONYM=YES is specified in the URT DBURTBL macro for that table.

SYNONYM Not Specified or SYNONYM=NO

If the URT does not specify SYNONYM or specifies SYNONYM=NO, DCCTFPR moves the DBID to the Request Area and returns the URT's ID to DCCTPPR.

SYNONYM=YES Specified

If the URT does specify SYNONYM=YES, DCCTFPR compares the DBID specified in the Request Area to the DBID in the URT as follows:

If the DBIDs match, DCCTFPR returns this URT's ID for additional processing.
If the DBIDs do not match, DCCTFPR checks for another hashing table entry and repeats the logic from the beginning of this section.