MVSFORUMS.com

[lacoe1]

Did anyone face the same problem I am having. Cursor FETCH keeps returning the same record again and again. If I use SPUFI it returns 19 records, but in the Application program it does not work. The application is coded as below.
OPEN
FETCH and process in loop
CLOSE

[dbzTHEdinosauer]

1. FETCH returns rows not records.

2. what does your DECLARE Cursor look like?

3. what does your FETCH look like?

4. what code are you executing that tells you that your FETCH is returning the same row, because it will not. Are you checking your SQL CODE after each FETCH.
_________________
Dick Brenholtz
American living in Varel, Germany

[Terry_Heinze]