1 FETCH 2? 2 NEXT 2 PRIOR 2 FIRST 2 LAST 2 BEFORE (1) 2 AFTER (2) 2 CURRENT 2 RELATIVE 2.1variable 2.1 integer 3! FROM 4 cursor-name 5? 5 single-fetch 5 multiple-row-fetch single-fetch: 1 INTO 1.1+ , 1.1variable 1INTO SQL DESCRIPTOR 1.1! LOCAL 1.1? 1.1 GLOBAL 1.2 SQL-descriptor-name 1 INTO DESCRIPTOR descriptor-name multiple-row-fetch: 1 FOR 2variable 2 integer 3 ROWS 4 INTO host-structure-array 4.0 USINGSQL DESCRIPTOR 4.0.1! LOCAL 4.0.1? 4.0.1 GLOBAL 4.0.2 SQL-descriptor-name 4.0 USING DESCRIPTOR descriptor-name 4.1 INTO row-storage-area row-storage-area: 1 : host-identifier-1 2! INDICATOR 2.1 : host-identifier-2
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.