declared with the `WITH ROWSET POSITIONING` clause 2. **Host variable arrays** — COBOL tables (OCCURS) sized to match your rowset 3. **The FETCH...FOR n ROWS syntax** — telling DB2 how many rows you want per call