Dynamic SQL statements are SQL statements that are prepared and executed within an application program while the program is running. In dynamic SQL, either:
When DB2 runs a dynamic SQL statement, it creates an access plan that is based on current catalog statistics and configuration parameters. This access plan might change from one execution of the statements application program to the next.
The alternative to dynamic SQL is static SQL.
[ Top of Page | Table of Contents | Glossary | Index ]