Host variable arrays

Use host variable arrays to pass a data array between DB2® and your application.

A host variable array is a data array that is declared in the host language to be used within an SQL statement. You can use host variable arrays to perform the following actions:
  • Retrieve data into host variable arrays for your application program's use
  • Place data into host variable arrays to insert rows into a table
You typically define host variable arrays for use with multiple-row FETCH, INSERT, and MERGE statements.