Called and calling program for cobol with cursor

I have program A which is calling B first time. B program is feaching data using cursor , but some mess happened and the control went back to pro A without closing cursor . Once again program A called program B then what will happen to cursor. will program fetch the data.

harish.jamkhande
Profile Answers by harish.jamkhande Questions by harish.jamkhande
Jun 11th, 2012
12
9955

Questions by harish.jamkhande

COBOL

Answer

Showing Answers 1 - 12 of 12 Answers

Latha

Jul 16th, 2012

Program B will throw an error while it is trying to open the cursor again, which is already opened.

TJ

Jan 22nd, 2014

I think it will throw SQL error code -502 i.e. when it will try to open the cursor that is already open.

Anand Jeyapaul

Oct 25th, 2017

How do we avoid the error code of -502? How do we close the cursor in the calling program?

Kalyan

Mar 20th, 2018

It depends on how program b is linked. Above answer is correct for statically linked. But if dynamically linked then program b will be in initial state in 2nd time and no error will come.