Dynamic SQL



next up previous contents
Next: SQL on a Up: Using SQL Previous: Embedded SQL

Dynamic SQL

Often, a SQL statement required by a program is not known when a program is compiled or even at the beginning of its execution. The need for a particular SQL statement may come about during program execution. SQL'92 includes the concept of dynamic SQL. A certain class of SQL statements may be executed at run time without having been passed through a preprocessor before program compilation like embedded SQL and without having been linked with procedures defined by the module language after compilation. This is accomplished by the Dynamic SQL capability which, given a SQL statement that can be executed at program run time, executes that statement immediately or prepares the statement for execution at some later time.



John Barkley
Fri Oct 7 16:17:21 EDT 1994