CA Ideal Commands › SET PLAN MAXSQL Command (DB2 Only)

SET PLAN MAXSQL Command (DB2 Only)

This command specifies the maximum number of SQL statements allowed in a CA Ideal SQL module. This maximum controls the size of each SQL module that CA Ideal generates as a result of the GENERATE PLAN command.

This command has the following format:

SET [SITE] PLAN MAXSQL nnnn