Back then, dynamic SQL in a DB2 environment meant COBOL programs with embedded dynamic SQL, which was not simple to code. So DBA groups created rules about avoiding dynamic SQL, and usually for good ...

If the programmer knows exactly what the query is going to do, and the query does not change, it is called "static SQL." If the query requires user input at runtime, it is called "dynamic SQL." ...