Message-ID: <0e268e59-cc7b-4c0d-aedc-3cfe2db9af45@iki.fi>
Date: Mon, 10 Nov 2025 13:43:03 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: ecpg Fetch issue
To: Tzuriel Kahlon <tzuriel.kahlon@surecomp.com>,
 "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
References: 
 <AM9PR06MB8017AE706EA6FEC256523716FDC1A@AM9PR06MB8017.eurprd06.prod.outlook.com>
Content-Language: en-US
From: Heikki Linnakangas <hlinnaka@iki.fi>
In-Reply-To: 
 <AM9PR06MB8017AE706EA6FEC256523716FDC1A@AM9PR06MB8017.eurprd06.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/0e268e59-cc7b-4c0d-aedc-3cfe2db9af45%40iki.fi>
Precedence: bulk

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