Quality Control for Dynamic SQL
Quality assurance measures for static SQL are commonplace in most installations. This is not the case whoever for dynamic SQL. Dynamic SQL is all too often shabbily treated although it makes an ever growing part of the load and bears more challenges than explained and proven static workload. The peculiar difficulty with dynamic SQL lies in the fact that normally the SQL statements are constructed only milliseconds before beingexecuted. DB2 system changes can have an instant effect on dynamic access paths. Static SQL, in contrast, is only affected after a REBIND.
For more information : SQLQC – Datasheet