Re: Resuse SQL Result Set?

I'm calling a SQL stored procedure from SQLRPGLE. It works fine for the
first call, but subsequent calls do not. The first EXEC SQL CALL properly
returns SQLSTATE 0100C, but subsequent calls return 00000.

What do I need to do to make multiple calls?

TIA

EXEC SQL CALL SCHEMA.PROC(:lFunction, :lInputParm);
aEqual(AD_HOC_RESULT_SETS :SQLSTATE);
EXEC SQL
associate result set locator (:ProcRS)
with procedure SCHEMA.PROC;
EXEC SQL close ProcCSR;
EXEC SQL allocate CSR cursor for result set :ProcRS;
aEqual(SUCCESS_SQL :SQLSTATE);

EXEC SQL FETCH NEXT FROM CSR INTO :lProcDs;
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.