Dynamic SQL is a facility that permits an interactive user to submit SQL statements dynamically to an application written using embedded SQL or stored procedures.
When contrasted with dynamic SQL, the facilities ordinary SQL provides are sometimes referred to as static SQL. For more information, see Dynamic Embedded SQL Statements.
Always use static SQL if possible, because dynamic SQL has a significant processing overhead that often impedes system performance.