MIME-Version: 1.0
References: <CANoyZGr5nSNGmWHT1bWY+F_k20WnvOhnKcZk0uq55GEYBAeRgA@mail.gmail.com>
 <CAHbZ42zwfodkVVHRU_4C4xOVh_hr1Pw0w4FueXj=srEZXwn=ag@mail.gmail.com>
In-Reply-To: <CAHbZ42zwfodkVVHRU_4C4xOVh_hr1Pw0w4FueXj=srEZXwn=ag@mail.gmail.com>
From: Tzuriel Kahlon <tzuriel1986@gmail.com>
Date: Tue, 9 Dec 2025 22:30:14 +0200
Message-ID: <CANoyZGoygwQXO_6Mt0uLdK6X21OnOoLN-FCs78AfU9cQ+Y6yKQ@mail.gmail.com>
Subject: Re: Ecpg fetch issue
To: Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002ecae306458ac845"
Archived-At: <https://www.postgresql.org/message-id/CANoyZGoygwQXO_6Mt0uLdK6X21OnOoLN-FCs78AfU9cQ%2BY6yKQ%40mail.gmail.com>
Precedence: bulk

--0000000000002ecae306458ac845
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 .


*=D7=91=D7=91=D7=A8=D7=9B=D7=94 *
*=D7=A6=D7=95=D7=A8=D7=99=D7=90=D7=9C =D7=9B=D7=97=D7=9C=D7=95=D7=9F *
0523851143

On Tue, Dec 9, 2025, 22:27 Juan Rodrigo Alejandro Burgos Mella <
rodrigoburgosmella@gmail.com> wrote:

> Hi
> When using ECPG, if you have a simple FETCH, it will do it row by row; th=
e
> 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 (<tzuriel1986@gmail.com>)
> escribi=C3=B3:
>
>> 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 th=
is
>> 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 wa=
nt
>> 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?
>>
>>
>>
>>
>>
>> *=D7=91=D7=91=D7=A8=D7=9B=D7=94 *
>> *=D7=A6=D7=95=D7=A8=D7=99=D7=90=D7=9C =D7=9B=D7=97=D7=9C=D7=95=D7=9F *
>> 0523851143
>>
>

--0000000000002ecae306458ac845
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div>Hey thank you for the answer , the solution you sugg=
est is modified the code in the application side i want to open the ecpg li=
ke procob in oracle and set it there without any intervention. On the code =
itself .</div><div><br></div><div data-smartmail=3D"gmail_signature"><div d=
ir=3D"rtl"><br><div><br></div><div><br></div><div><i>=D7=91=D7=91=D7=A8=D7=
=9B=D7=94=C2=A0</i></div><div><b>=D7=A6=D7=95=D7=A8=D7=99=D7=90=D7=9C =D7=
=9B=D7=97=D7=9C=D7=95=D7=9F=C2=A0</b></div><div>0523851143</div></div></div=
></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr=
" class=3D"gmail_attr">On Tue, Dec 9, 2025, 22:27 Juan Rodrigo Alejandro Bu=
rgos Mella &lt;<a href=3D"mailto:rodrigoburgosmella@gmail.com">rodrigoburgo=
smella@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><di=
v dir=3D"ltr"><div>Hi</div><div>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.</div><div></div><div>In my case, when I want to e=
xtract, for example, 100 records at once, I use the following model:</div><=
div><br></div><div>I define a data array:</div><div><br></div><div>EXEC SQL=
 BEGIN DECLARE SECTION;<br>struct _resultData {<br>	int =C2=A0int_data1;<br=
>	char chr_data2[11];<br>} resultData[100];<br>EXEC SQL END DECLARE SECTION=
;<br><br></div><div>and then in the fetch:</div><div><br></div><div>	EXEC S=
QL<br>	FETCH FORWARD 100 cCursor<br>	INTO :resultData;<br><br></div><div>an=
d the variable sqlca.sqlerrd[2] controls the number of records returned</di=
v><div><br></div><div>I hope it helps you</div><div><br></div><div>Atte</di=
v><div>JRBM</div><div><br></div></div><br><div class=3D"gmail_quote"><div d=
ir=3D"ltr" class=3D"gmail_attr">El mar, 9 dic 2025 a las 14:53, Tzuriel Kah=
lon (&lt;<a href=3D"mailto:tzuriel1986@gmail.com" target=3D"_blank" rel=3D"=
noreferrer">tzuriel1986@gmail.com</a>&gt;) escribi=C3=B3:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div>Hey all ,<=
/div><div dir=3D"auto">We are using IBM for cobol and connextint postgres d=
b 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 approac=
h to db and this decrease the performance significantly if twvle have 10000=
0 rows it take it one by one each run .</div><div dir=3D"auto">In procob wh=
ich is the precompiler of Oracle there are option to set the prefetch to ta=
ke in each time it approach the db x number of rows you want and this ease =
the db retrieved and enhance the performance .</div><div dir=3D"auto">I kno=
w 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 m=
iddle between cobol and db.</div><div dir=3D"auto">There is anyone from you=
 which encountered same issue?</div><div dir=3D"auto"><br></div><div><br></=
div><div><div dir=3D"rtl"><br><div><br></div><div><br></div><div><i>=D7=91=
=D7=91=D7=A8=D7=9B=D7=94=C2=A0</i></div><div><b>=D7=A6=D7=95=D7=A8=D7=99=D7=
=90=D7=9C =D7=9B=D7=97=D7=9C=D7=95=D7=9F=C2=A0</b></div><div>0523851143</di=
v></div></div></div>
</blockquote></div>
</blockquote></div>

--0000000000002ecae306458ac845--