ESL's ORACLE support includes batch commands that access ORACLE's array-handling interface. The ESL's ODBC interface also supports certain array commands, although the size is limited to a single row of values. These commands are listed in the table and facilitate the transfer of data between ESL applications and ORACLE or ODBC databases when performing multiple INSERTs, DELETEs and UPDATEs.
Command |
Description |
With ORACLE this command transfers any currently buffered rows and terminates batch mode. For ODBC this command executes the SQL statement previously specified in an astmt commaned using the values specified by the last aval command. |
|
(ORACLE only) Sets the batch size by allocating memory to hold the number of rows specified. With the ODBC interface the batch size is limited to the default of 1 row of values. |
|
Defines the SQL INSERT, UPDATE, or DELETE statement to be executed in subsequent batch commands. As the ODBC batch commands only allow a single row of values, SQL SELECT statement are acceptable. |
|
Provides data values for use with an SQL statement previously specified in an astmt command. |
