Embeded SQL ODP problem

["Schadd D Gray" <list@xxxxxxxxxxxxx>]

I have a SQLRPGLE with a select statement in it.  I have compiled this program 
with CLOSQLCSR(*ENDMOD).  However, after the program finishes I look at the 
Open Data Paths for my job and the files in the SELECT statement are still 
open.  I close the cursor prior to exiting the program.

I put the program in debug and my joblog shows the message SQL7914 "ODP not 
deleted".

The main place this is causing me issue is in JDBC calls to these SQLRPGLE 
programs, which are registered as stored procedures.  The system jobs for JDBC 
end up having 300+ ODP's.

Is there a way to ensure the ODP's are deleted?

By the way, this is a hard coded SELECT statement (Not a prepared statement).

OS - V5R2

Thanks,
Schadd Gray
Damon Technologies, Inc.
www.damontech.com