Reason:
The number of SQL statements in one or more programs exceeds the current maximum allowed for your session or site. The Impact Report designates such programs with the EXCLIM status.
Action:
The maximum number of SQL statements permitted for static SQL execution is set by the command SET PLAN MAXSQL nnnn that cannot exceed your site standard maximum. Consider breaking the programs into one or more subprograms, to segregate activity and lower the number of SQL statements per program. Consider whether restructuring the programs or the queries to more general forms involving host-variables instead of constants would reduce the number of SQL statements. You might want to run the program in DYNAMIC SQL mode instead of rewriting or restructuring the program. Take appropriate action based on your research. Consider resetting the session or site maximum for static SQL statements.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|