Re: Resuse SQL Result Set?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I don't understand your question...

SQLSTATE 00000 is "successful" ...?

Why are you closing "ProcCSR", yet allocating and fetching from "CSR"?

Charles

On Fri, Sep 1, 2023 at 9:31 AM Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:

> 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.