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 |