Re: SQL Cursor Position Problem in V5R3?

Brad Stone wrote:
> 
> I am working with a customer who is having a problem with
> what seems like a cursor position problem using embedded
> SQL.
> 
> Prior to V5R3 the program worked fine.  Now, when they run
> it the first time, it works fine, but the next time they
> run it it produces no results, as if it started reading at
> the EOF.
> 

It might be an activation group difference, if the program is created
with CRTPGM and the ACTGRP parameter is not specified.

Prior to V5R3, a simple CRTPGM always created a program in *NEW
activation group.  In V5R3 it was changed so that the default value used
for the ACTGRP parameter depends on the type of program-entry module. 
For RPGLE modules, the default is QILE, not *NEW.