Date: Fri, 29 Mar 2024 03:22:50 +0100 (CET) Message-ID: <1871546493.111418.1711678970136@srvdoc.doc.ipesoft.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_111417_1555453170.1711678970136" ------=_Part_111417_1555453170.1711678970136 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
DB_INSERT handleIdent_Int, ro= wIdent, retCodeIdent_Int [ORAHINT hintIdent_Str] =20 DBS_INSERT dbObjIdent, rowIdent, retCodeIdent_Int [TRANS transHandle_Int] [= ORAHINT hintIdent_Str]
DB_INSERT handleIdent_Int, st= ructIdent, retCodeIdent_Int [ORAHINT hintIdent_Str] =20 DBS_INSERT dbObjIdent, structIdent, retCodeIdent_Int [TRANS transHandle_In= t] [ORAHINT hintIdent_Str]
handleIdent_Int | in | Identifier (handle) of Int type of the connection wit= h a table (DB_CONNECT). |
dbObjIdent | in | Reference to an object of Database table. |
rowIdent | in | One structure row identifier (row to insert)= . |
structIdent | in | Identifier of a whole structure (rows to inse= rt). |
retCodeIdent_Int | out | Return value of Int type - action success. |
transHandle_Int | in | Identifier of the Connection to the database. |
hintIdent_Str | in | Expression of String type that defines =
Oracle SQL hint. It is used as an instruction for the performance optimizer=
of SQL command. The value is used without the opening and terminating char=
acters /*+ <orahint> */. The example is mentioned here. |
For D2000 v5.00: an disadvantage of the action =
DBS_INSERT is in speed. Each DBS_INSERT call resu=
lts in necessity to open and close the database in DBManager - it can be a =
time-consuming operation and it is a comparatively nonstandard method in te=
rm of databases.
The need to open and close the database may be avoided in the scope of tra=
nsaction processing so that the command is followed by the parameter
TRANS
For D2000 v6.00 and higher: DBManager opt= imization (connection recycling, predefined connections) causes, that t= he action DBS_INSERT is executes as quick as the acti= on DB_INSERT and as moreover there is saved a time require= d for execution of the action DB_CONNECT to open the datab= ase.
Related pages: