RPG/DB2 Cursor as a resultset being cleared -


i have rpg program/stored procedure returns resultset .net program. working fine until rpg added code after

... return client cursor c1...  // new line of code ... delete <file>... 

why resultset empty when deleted file? shouldnt resultset in cursor c1?

what trying call rpg stored procedure , have procedure return me resultset file delete records int file. thought setting resulset retain data after delete actuall data in db. looks if delete records resultset cleared

you put chosen records in temp table, delete them original file, return result set of temp table.


Comments

Popular posts from this blog

java - Jmockit String final length method mocking Issue -

asp.net - Razor Page Hosted on IIS 6 Fails Every Morning -

c++ - wxwidget compiling on windows command prompt -