What is the FLUSH PACKAGE CACHE statement used for?
A.
It saves dynamic SQL stored in the package cache to an external file.
B.
To remove all cached static SQL statements from the package cache.
C.
To remove all cached dynamic SQL statements from the package cache.
D.
It causes all SQL statements in the package cache that are currently in use to be recompiled.
The FLUSH PACKAGE CACHE statement removes all cached dynamic SQL statements currently in the package cache. This statement causes the logical invalidation of any cached dynamic SQL statement and forces the next request for the same SQL statement to be implicitly compiled by DB2®.
0
0