Assuming I am working on a COBOL DB2 program. A batch program. I execute a SQL query in the program which causes a SQLCODE -811. Now which row will be fetched in DCLGEN or host variable as the select statement had fetched more than one row and with -811 SQL code? Obviously there are duplicates but which duplicate is there?
Will the "fetch first row only" fetches the same row, as the row fetched when we handle -811 SQLCODE?
![Question :?:](./images/smilies/icon_question.gif)