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

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

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 (<tzuriel1986@gmail.com>)
escribi=C3=B3:

> 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 oracl=
e
> 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;
>> 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 returne=
d
>>
>> 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 t=
his
>>> decrease the performance significantly if twvle have 100000 rows it tak=
e it
>>> one by one each run .
>>> In procob which is the precompiler of Oracle there are option to set th=
e
>>> prefetch to take in each time it approach the db x number of rows you w=
ant
>>> 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 ecp=
g
>>> 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
>>>
>>

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

<div dir=3D"ltr"><div>The issue is that there&#39;s no direct ECPG for COBO=
L; ECPG is a C preprocessor and can only be used as an external function. A=
lternatively, you can use libpq as a wrapper, but you&#39;ll still need to =
compile the C code.</div><div><br></div><div>Atte</div><div>JRBM</div></div=
><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" clas=
s=3D"gmail_attr">El mar, 9 dic 2025 a las 15:30, Tzuriel Kahlon (&lt;<a hre=
f=3D"mailto:tzuriel1986@gmail.com">tzuriel1986@gmail.com</a>&gt;) escribi=
=C3=B3:<br></div><blockquote 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 thank you for the answer , the solution you suggest is m=
odified the code in the application side i want to open the ecpg like proco=
b in oracle and set it there without any intervention. On the code itself .=
</div><div><br></div><div><div dir=3D"rtl"><br><div><br></div><div><br></di=
v><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"><div d=
ir=3D"ltr" class=3D"gmail_attr">On Tue, Dec 9, 2025, 22:27 Juan Rodrigo Ale=
jandro Burgos Mella &lt;<a href=3D"mailto:rodrigoburgosmella@gmail.com" tar=
get=3D"_blank">rodrigoburgosmella@gmail.com</a>&gt; wrote:<br></div><blockq=
uote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1p=
x solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Hi</div><d=
iv>When using ECPG, if you have a simple FETCH, it will do it row by row; t=
he way to download more than one row at a time is by using data arrays.</di=
v><div></div><div>In my case, when I want to extract, for example, 100 reco=
rds 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>st=
ruct _resultData {<br>	int =C2=A0int_data1;<br>	char chr_data2[11];<br>} re=
sultData[100];<br>EXEC SQL END DECLARE SECTION;<br><br></div><div>and then =
in the fetch:</div><div><br></div><div>	EXEC SQL<br>	FETCH FORWARD 100 cCur=
sor<br>	INTO :resultData;<br><br></div><div>and the variable sqlca.sqlerrd[=
2] controls the number of records returned</div><div><br></div><div>I hope =
it helps you</div><div><br></div><div>Atte</div><div>JRBM</div><div><br></d=
iv></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_att=
r">El mar, 9 dic 2025 a las 14:53, Tzuriel Kahlon (&lt;<a href=3D"mailto:tz=
uriel1986@gmail.com" rel=3D"noreferrer" target=3D"_blank">tzuriel1986@gmail=
.com</a>&gt;) escribi=C3=B3:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><div dir=3D"auto"><div>Hey all ,</div><div dir=3D"auto">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 corr=
ectly 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 .</div><div dir=3D"auto">In procob which is the precompiler of Ora=
cle there are option to set the prefetch to take in each time it approach t=
he db x number of rows you want and this ease the db retrieved and enhance =
the performance .</div><div dir=3D"auto">I know that there is a way to chan=
ge the setting in the application code, but I want to eliminate touch any c=
ode and configure only the ecpg which is the middle 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</div></div></div></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>

--000000000000c41bc606458b0d9a--