I have stumbled across a very strange issue. My COBOL program was issuing a Row not found error, and returning the conditions back to me. I used these conditions and pulled the same query with AQT for windows and determined that there was one row that should be returning for the conditions. However, AQT also returned me this error:
" SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000
1 row displayed (14.03 secs)"
Has anyone ever heard of a situation like this? We have recently upgraded to V9 and was wondering if this was a possibly linked.
Any help would be appreciated. Thanks
" SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000
1 row displayed (14.03 secs)"
Has anyone ever heard of a situation like this? We have recently upgraded to V9 and was wondering if this was a possibly linked.
Any help would be appreciated. Thanks