TABLES IN STMT field
The value of the TABLES IN STMT field indicates the estimated average number of tables that is to be used per SQL statement.
| Acceptable values: | 1–16 |
|---|---|
| Default: | 2 |
| Update: | see Updating subsystem parameter and application default values; cannot update during migration |
| DSNZPxxx: | none |
Some SQL statements use more than one table (for example, those using joins, unions, or subselect clauses). Consider how often you expect to use such statements when choosing a value for this parameter.