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 |