Hey thank you for the answer , the solution you suggest is modified the code in the application side i want to open the ecpg like procob in oracle and set it there without any intervention. On the code itself .
*בברכה * *צוריאל כחלון * 0523851143 On Tue, Dec 9, 2025, 22:27 Juan Rodrigo Alejandro Burgos Mella < [email protected]> wrote: > Hi > When using ECPG, if you have a simple FETCH, it will do it row by row; the > way to download more than one row at a time is by using data arrays. > In my case, when I want to extract, for example, 100 records at once, I > use the following model: > > I define a data array: > > EXEC SQL BEGIN DECLARE SECTION; > struct _resultData { > int int_data1; > char chr_data2[11]; > } resultData[100]; > EXEC SQL END DECLARE SECTION; > > and then in the fetch: > > EXEC SQL > FETCH FORWARD 100 cCursor > INTO :resultData; > > and the variable sqlca.sqlerrd[2] controls the number of records returned > > I hope it helps you > > Atte > JRBM > > > El mar, 9 dic 2025 a las 14:53, Tzuriel Kahlon (<[email protected]>) > escribió: > >> Hey all , >> We are using IBM for cobol and connextint postgres db with ecpg the >> precompiler , problem is when we running cursor against db the prefetch are >> not set correctly and provide one row each time he approach to db and this >> decrease the performance significantly if twvle have 100000 rows it take it >> one by one each run . >> In procob which is the precompiler of Oracle there are option to set the >> prefetch to take in each time it approach the db x number of rows you want >> and this ease the db retrieved and enhance the performance . >> I know that there is a way to change the setting in the application code, >> but I want to eliminate touch any code and configure only the ecpg which is >> the middle between cobol and db. >> There is anyone from you which encountered same issue? >> >> >> >> >> >> *בברכה * >> *צוריאל כחלון * >> 0523851143 >> >
