.-FROM-. >>-FETCH--+------------------------+--+------+--cursor-name-----> +-NEXT-------------------+ +-PRIOR------------------+ +-FIRST------------------+ +-LAST-------------------+ | (1) | +-BEFORE-----------------+ | (2) | +-AFTER------------------+ +-CURRENT----------------+ '-RELATIVE--+-variable-+-' '-integer--' >--+--------------------+-------------------------------------->< +-single-fetch-------+ '-multiple-row-fetch-' single-fetch: .-,--------. V | |--+-INTO----variable-+-------------------------------------+---| | .-LOCAL--. | +-INTO--SQL--DESCRIPTOR--+--------+--SQL-descriptor-name-+ | '-GLOBAL-' | '-INTO DESCRIPTOR--descriptor-name-----------------------' multiple-row-fetch: |--FOR--+-variable-+--ROWS--------------------------------------> '-integer--' >--+-INTO--host-structure-array----------------------------------------------------------+--| | .-LOCAL--. | '-+-USING--SQL--DESCRIPTOR--+--------+--SQL-descriptor-name-+--INTO--row-storage-area-' | '-GLOBAL-' | '-USING DESCRIPTOR--descriptor-name-----------------------' row-storage-area: |--:--host-identifier-1--+-------------------------------------+--| | .-INDICATOR-. | '-+-----------+--:--host-identifier-2-'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.