Re: ecpg Fetch issue

On 09/11/2025 15:26, Tzuriel Kahlon wrote:
> Hey ,
> my progra running from Cobol and im using ECPG for that the issue is
> when i use FETCH command the fetch going one by one
> and not take all the rows in batch , there is any solution for that
> regard to change the code itself ?

There's an example in the docs that fetches multiple rows into an array.
See https://www.postgresql.org/docs/18/ecpg-descriptors.html:

> PostgreSQL supports retrieving more that one record in one FETCH statement and storing the data in host variables in this case assumes that the variable is an array. E.g.:
>
> EXEC SQL BEGIN DECLARE SECTION;
> int id[5];
> EXEC SQL END DECLARE SECTION;
>
> EXEC SQL FETCH 5 FROM mycursor INTO SQL DESCRIPTOR mydesc;
>
> EXEC SQL GET DESCRIPTOR mydesc VALUE 1 :id = DATA;

P.S. Please post usage questions like this to pgsql-general in the
future, the pgsql-bugs list is for reporting bugs.

- Heikki