While embedded SQL is fine for fixed applications, sometimes it is important for a program to dynamically create entire SQL statements. With dynamic SQL, a statement stored in a string variable can be issued. PREPARE turns a character string into a SQL statement, and EXECUTE executes that statement.

PREPARE and EXECUTE may be combined into one statement using the IMMEDIATE clause of the EXECUTE statement.