Please enable JavaScript to view this site.

ESL Documentation

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

aexec

Transfers any currently buffered rows and terminates batch mode.

asize

Sets the batch size by allocating memory to hold the number of rows specified.

astmt

Defines the SQL INSERT, UPDATE, or  DELETE statement to be executed in subsequent batch commands.

aval

Provides data values for use with an SQL statement previously specified in an stmt command.