Can embedded SQL in a subprocedure return results sets to a CLLE?

[meovino@xxxxxxxxxxxxxxxxx]

I've managed to get an ILE RPG program with embedded SQL to return a 
result set, and if I call that program from Net.Data, I can get the result 
set into a Net.Data table variable.  Works very nicely, and will hopefully 
get us away from so much Net.Data coding.  But we're trying to get away 
from RPG programs and toward writing RPG subprocedures that are called by 
CLLE programs.  Is it possible to turn my RPG program into a subprocedure 
and call it from a CLLE in such a way that it will receive the returned 
result set and pass it back to my Net.Data macro?

I've tried this, and I'm getting an error saying that there are no result 
sets available from my CLLE program (sqlstate 01646, sqlcode 7050).

Thanks!

Mike E.