Cursors > Processing SQL Statements
 
Processing SQL Statements
SQL statement are usually sent for processing one at a time. However, some RDBMSs allow you to send a batch of several statements at once: such is the case of Sybase, MS SQL Server, and ODBC if the underlying RDBMS allows it.
Although it is not forbidden by Rogue Wave DB Link, we do not recommend using batches of statements. Stored procedures are far more convenient.
Two different processes exist with respect to statement execution:
*Immediate Execution: The SQL statement is sent to the server immediately via the function IldRequest::execute.
*Deferred Execution: The execution process is broken down into the following steps:
*The SQL statement is prepared by the function IldRequest::parse.
*The parameters are bound and set.
*The actual execution takes place when the function IldRequest::execute is called.
You should choose immediate execution when the query has no placeholder (or parameter) and will be used only once.
Version 5.8
Copyright © 2014, Rogue Wave Software, Inc. All Rights Reserved.