Specifying the Maximum Number of Rows in the Diagnostics Table (IDS)

The following statement starts violations and diagnostics tables for the target table named orders. The MAX ROWS clause specifies the maximum number of rows that can be inserted into the diagnostics table when a single statement, such as an INSERT statement, is executed on the target table.

START VIOLATIONS TABLE FOR orders MAX ROWS 50000