The ISAM processor has reached its limit of open files. For C-ISAM programs, review the program logic and change it so that fewer files are open concurrently. Use isclose to close unneeded files. For SQL products, this query is too complex; it uses too many tables concurrently. For example, a trigger procedure running with PDQ enabled can open many tables during constraints processing. Perform the query in steps, and use temporary tables.