I am using dynamic sql in an rpgle pgm. This pgm is called from 2 different menu options. When I take the 2nd option, everything works fine. I exit out of that option and take the first option. Everything is still work fine. I exit the first option and go back to the 2nd option and the pgm hangs up when I open the cursor in the sql open statement. I am sure the cursor has been closed. Anyone have any suggestions? Thanks.
June 18, 2008 4:33 PM
April 27, 2010 7:30 AM