Prepared Execution
You can use this technique for any SQL request that you can (or must) compile before executing. Prepared execution compiles each SQL request and executes the compiled request any number of times without recompiling. This technique is necessary for dynamic cursor specifications and statements that contain dynamic parameter markers. Thus, a request string can contain the following SQL statements for prepared execution:
For UPDATE and INSERT statements, dynamic parameter markers provide an alternative means to set column values from your application. For cursor specifications, the dynamic FETCH statement returns column data to your application.
To implement prepared execution, ESQL provides a number of Progress/ESQL statements and supporting ESQL-LIB functions. For more information, see the "Using Prepared Execution" section in this chapter.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |