Re: Files left open after SQLRPGLE is finished

[rob@xxxxxxxxx]

Or he could use the SQL command to close the cursor in his RPG program.
C/EXEC SQL
C+ Close Cur1
C/END-EXEC

LR should close all files opened with F specs.  Not necessarily SQL files.
Not arguing with you Bob.  This last paragraph is more to the originator.


Rob Berendt

==================
Remember the Cole!


                                                                                
                                       
                    "Bob                                                        
                                       
                    Slaney/Atlanta/IB        To:     RPG400-L@MIDRANGE.COM      
                                       
                    M"                       cc:                                
                                       
                    <rjslaney@us.ibm.        Subject:     Re: Files left open 
after SQLRPGLE is finished               
                    com>                                                        
                                       
                    Sent by:                                                    
                                       
                    owner-rpg400-l@MI                                           
                                       
                    DRANGE.COM                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    10/18/00 12:24 PM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       




Maybe these files are using a cursor? Do you close the cursor explicitly in
the program? Also, check your CRTSQLRPGI cursor option:

Close SQL cursor . . . . . . . .   *ENDACTGRP    (*ENDMOD, *ENDACTGRP)

In your case, it would probably better to use *ENDMOD

If you're doing the above stuff already, I would like to look at your
program and see what I can spot.

Bob

Bob Slaney/Atlanta/IBM @ IBMUS (Lotus Notes)
VM id: WTSCPOK.RJSLANEY@VM
Internet id: rjslaney@us.ibm.com
Tieline 596-3022 Direct (770)835-3022
Fax tie 596-3912 Direct (770)835-3912

IBM Learning Services
AS/400 Course Materials Development
IBM Corp.
3100 Windy Hill Road
Atlanta, GA 30339
Internal Zip WE3A1

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---