Thread

1. ecpg Fetch issue

   Tzuriel Kahlon <tzuriel.kahlon@surecomp.com> — 2025-11-09T13:26:30Z

   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 ?
   
   
   Regards,
   
   --
   
   Tzuriel Kahlon
   
   DBA
   
   
   
   [cid:8ae894a1-7844-4af3-a977-fb19f725f472]<http://www.surecomp.com/rivo-trade>
   
   
   

2. Re: ecpg Fetch issue

   Heikki Linnakangas <hlinnaka@iki.fi> — 2025-11-10T11:43:03Z

   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