Reason:
The number of SQL modules in the PLAN just generated exceeds the CA Ideal maximum of 10. The number of SQL statements per module is established through the SET RUN SQL nnnn command.
Action:
Consider altering the value of SET RUN SQL to increase the number of statements per SQL module. Consider subdividing the application into several smaller applications to minimize the number of SQL statements per plan. Be certain that references to SQL statements in your programs actually are needed. Consider consolidating SQL access in individual programs to minimize SQL statements employed. Correct the errors and re-specify.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|