Nonstop Database, HiRDB Version 9 UAP Development Guide
When searching for data by specifying conditions for multiple repetition columns in a table that has repetition columns, use a structured repetition predicate.
The following figure shows, as an example of a data search using a structured repetition predicate, the procedure for searching the staff table for those employees who list a father as a family member.
Figure 2-29 Data search example using a structured repetition predicate
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.