Apart from DB procedures and triggers, ADABAS also supports arrays as host variables to enhance performance in client-server configurations in the statements INSERT, UPDATE, DELETE, SELECT, and FETCH. Thus it is possible to process not only one row of a table but a large number of rows with one SQL statement. This reduces the interaction between client and server.
In the case of FETCH statements, the attempt is always made to transfer more than one row of the table into the application program. No special programming is required.