Re: Embedded SQL in an RPG *SRVPGM, file stays open

Part of the problem may be with the Activation Group.
Regardless of when you officialy CLOSE the SQL Cursor, the file remains active
in the jobs Activation Group until it ends. If you have set the cursor to
close at *ENDMOD, your cursor will be closed, but if you look at the Open Files
in the job, you will still see the file. In fact, if you then call the SQL
Program again, it will *NOT* use the existing file in the job, but open it
again each time.
The only time this has been a problem was when the program was being run
interactivly and the activation group was not deleted. The only solution I
have found was to make any interactive SQL program run in activation group *NEW.


Jeff Young
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions Designer
V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions
Implementer V5R3









----- Original Message ----
From: "rob@xxxxxxxxx" <rob@xxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Monday, April 9, 2007 2:35:22 PM
Subject: Re: Embedded SQL in an RPG *SRVPGM, file stays open


I do not believe %open will tell you squat about files opened with SQL.

Rob Berendt