Immediate Execution

You can use this technique for any SQL request that you can complete in one statement and that does not return data to your application. Immediate execution compiles and executes the SQL statement in the request string each time you invoke it. A request string can contain the following SQL statements for immediate execution:

For UPDATE and INSERT statements, specify all column data values in the request string.

To implement immediate execution, ESQL provides the Progress/ESQL EXECUTE IMMEDIATE statement and the supporting sqldynrq() ESQL-LIB function. For more information, see the "Using Immediate Execution" section.


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