FIND Limitations

Observe the following important limitations when constructing a FIND or COUNT statement.

A maximum of 17 tables can be related or used in a FIND or COUNT statement. The number of tables is based on the following considerations:
1. The total number of tables is developed after Join Optimization processes the statement.
2. Repeating relationships or complex WITH statements can cause an increase in the total number of tables the query uses.
3. The record at a time (RAAT) Long Key feature of CA Datacom 15.0 cannot be used in a Dataquery Relate of two files.
Three parameters in the System Option Table limit the execution of a FIND or COUNT statement:
- FNDBLKS: Maximum number of logical allocated blocks in the work table for this query.
- MFTIME: Maximum number of seconds for the FIND or COUNT verb to execute.
- SRCHLIM: Maximum number of DATACOM/DB physical I/Os allowed during the execution of a FIND or COUNT statement.