Re: Ecpg fetch issue

2025-12-09 Thread Tzuriel Kahlon
Yes , and this is our issue that we try to solve in our product , we are working with IBM for cobol and try our luck to see if someone get any advance on that topic. *בברכה * *צוריאל כחלון * 0523851143 On Tue, Dec 9, 2025, 22:49 Juan Rodrigo Alejandro Burgos Mella < [email protected]

Re: Ecpg fetch issue

2025-12-09 Thread Juan Rodrigo Alejandro Burgos Mella
The issue is that there's no direct ECPG for COBOL; ECPG is a C preprocessor and can only be used as an external function. Alternatively, you can use libpq as a wrapper, but you'll still need to compile the C code. Atte JRBM El mar, 9 dic 2025 a las 15:30, Tzuriel Kahlon () escribió: > Hey thank

Re: Ecpg fetch issue

2025-12-09 Thread Tzuriel Kahlon
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 Alejand

Re: Ecpg fetch issue

2025-12-09 Thread Juan Rodrigo Alejandro Burgos Mella
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

Ecpg fetch issue

2025-12-09 Thread Tzuriel Kahlon
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 10 rows it ta