Using Prepared Execution

Use prepared execution for the following types of SQL statements:

For a complete list of statements with which you can use prepared execution, see the "Executing Dynamic ESQL" section in this chapter. You can use prepared execution for any SQL statement except singleton SELECTs. However, there is no benefit in doing so for statements that you can invoke using immediate execution and only need to execute once in an ESQL session. This is especially true for DDL statements because of how prepared execution operates.


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