Limitations of Static SQL
As the name static SQL implies, a program built using the embedded SQL features described in Chapter 17 (host variables, cursors, and the DECLARE CURSOR, OPEN, FETCH, and CLOSE statements) has a predetermined, fixed pattern of database access. For each embedded SQL statement in the program, the tables and columns referenced by that statement are [ [ ...]