Previous Topic: Executing a Positioned Update or DeleteNext Topic: Executing a Bulk Fetch


Bulk Processing

A CA IDMS extension of the SQL standard allows you to transfer multiple rows of data between the database and the program using a single SELECT, FETCH, or INSERT statement with a BULK clause.

To issue a bulk select, fetch, or insert, the program must declare a host variable array.

Note: For more information about declaring a host variable array in CA ADS, COBOL and PL/I see Requirements and Options for Host Languages.