Using Dynamic Embedded SQL

Dynamic ESQL is a variant of Embedded SQL that allows your ESQL application to create SQL statements at run time. Unlike static ESQL, you do not have to define the text of dynamic ESQL statements at application development time. Instead you can enter them directly, generate them from user prompts, or generate them at run time using a third-party application such as a spreadsheet.

Dynamic ESQL also allows you to prepare, compile, and execute (run) statements that contain parameter markers. Parameters markers are place holders in SQL expressions for values that your application provides when it executes a statement. Using parameter markers, you can prepare a statement once and execute the same SQL statement repeatedly, substituting different values for the parameters each time, without incurring repeated compiler overhead.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095