Static and Dynamic ESQL
Progress/ESQL supports two basic types of Embedded SQL:
- Static Embedded SQL — SQL statements fully specified at host language compile time, with the option to precompile the SQL syntax before application run time. Precompiling your SQL can save significant execution time and space on some platforms.
- Dynamic Embedded SQL — SQL statements fully specified at application run time, when they are compiled and executed dynamically. With dynamic ESQL, you can specify the exact form of your SQL statements based on run-time input. Dynamic ESQL also features dynamic parameter markers, which are place holders for values that you supply in run-time SQL expressions. Using parameter markers, you can execute the same SQL statement repeatedly, substituting different values for the parameters each time.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |