When you are considering dynamic SQL over static SQL or vice versa, you should also understand that dynamic SQL uses only statements that can be dynamically prepared. Hence, dynamic SQL must be any of the following statements shown in Table 7.1
Different methods are available for you to work with dynamic SQL in SQL procedures, and the following subsections will discuss each in turn.
On zSeries, some statements can be dynamically prepared only if DYNAMICRULES run behavior is implicitly or explicitly specified. Refer to the corresponding SQL Reference manual for details.