In addition to the commands that are also available for accessing DB/2, SQL Server, and Sybase databases, ESL's ORACLE support includes commands that access ORACLE's array-handling interface. These commands are listed in the table and facilitate the transfer of data between ESL applications and ORACLE databases. They allow you to update or insert rows in an SQL table by specifying multiple occurrences of similar records in a batch operation. Compared to sending individual commands sequentially, these commands can enhance performance, as they cause a set of commands to be sent as a single network transmission. You may find these commands useful in transaction processing applications where performance is critical. Note, however, that records are not posted to the target database until the batch is sent.
Command |
Description |
Transfers any currently buffered rows and terminates batch mode. |
|
Sets the batch size by allocating memory to hold the number of rows specified. |
|
Defines the SQL INSERT, UPDATE, or DELETE statement to be executed in subsequent batch commands. |
|
Provides data values for use with an SQL statement previously specified in an stmt command. |