Date: Fri, 29 Mar 2024 10:03:11 +0100 (CET) Message-ID: <39335629.111610.1711702991227@srvdoc.doc.ipesoft.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_111609_1234123667.1711702991226" ------=_Part_111609_1234123667.1711702991226 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
PG_READ handleIdent_Int, pag= eNrIdent_Int, locVarArrIdent, retCodeIdent_Int
handleIdent_Int | in | Identifier of Int type (handle) of the connect= ion to a table (returned by the action PG_CONNECT). |
pageNrIdent_Int | in | Identifier of Int type of required page number= (from 1 =E2=80=A6). |
locVarArrIdent | out | Identifier local variable of Record type (whole structur= e) - read result. |
retCodeIdent_Int | out |
Identifier of Int type - action success. |
pageNrIdent_Int
.=
Pages in the table are numbered from one (1 ...). The performance of SQL e=
xpression SELECT for Oracle, stated in PG_CONNECT, can be influenced by using the Oracle SQL hint (para=
meter in PG_CONNECT).retCodeIden_Int =3D _ERR_NO_ERROR
),=
then the reading result (required page) is assigned to the local variable =
locVarArrIdent_Int
. In case of need, the local variable array =
size is changed. The structure type of the local variable must be equal wit=
h the type of the table. If the reading result is empty data (the error _ER=
R_NO_DATA), the local array will be resized to the size of 0. Related pages: