Date: Fri, 29 Mar 2024 08:30:59 +0100 (CET) Message-ID: <1191054104.111550.1711697459374@srvdoc.doc.ipesoft.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_111549_862018195.1711697459373" ------=_Part_111549_862018195.1711697459373 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
DB_UPDATE handleIdent_Int, r= owIdent, retCodeIdent_Int [WHERE strExpression_Str [BINDIN varIdent1, varId= ent2, ... ]] [ORAHINT hintIdent_Str]=20 DB_UPDATE handleIdent_Int, rowIdent, retCodeIdent_Int [WHERE strExpression= _Str [BINDIN structRowIdent]] [ORAHINT hintIdent_Str]=20 DBS_UPDATE dbObjIdent, rowIdent, retCodeIdent_Int [WHERE strExpression_Str= [BINDIN varIdent1, varIdent2, ... ]] [TRANS transHandle_Int] [ORAHINT hint= Ident_Str]=20 DBS_UPDATE dbObjIdent, rowIdent, retCodeIdent_Int [WHERE strExpression_Str= [BINDIN structRowIdent]] [TRANS transHandle_Int] [ORAHINT hintIdent_Str] <= /pre>
DB_UPDATE handleIdent_Int, st= ructIdent, retCodeIdent_Int [ORAHINT hintIdent_Str]=20 =20 DBS_UPDATE dbObjIdent, structIdent, retCodeIdent_Int [TRANS transHandle_Int= ] [ORAHINT hintIdent_Str]
handleIdent_Int | in | Identifik=C3=A1tor typu Int - (handle) spojen= ia s datab=C3=A1zou (DB_CONNECT<= /a>). |
dbObjIdent | in | Odkaz na objekt typu Tabu=C4=BEka. |
rowIdent | in | Identifik=C3=A1tor jedn=C3=A9ho riadku =C5=A1tru= kt=C3=BAry (vkladan=C3=BD riadok). |
structIdent | in | Identifik=C3=A1tor celej =C5=A1trukt=C3=BAry= (vkladan=C3=A9 riadky). |
retCodeIdent_Int | out | N=C3=A1vratov=C3=A1 hodnota typu Int - =C3= =BAspe=C5=A1nos=C5=A5 akcie. |
strExpression_Str | in | V=C3=BDraz typu String, ktor=C3=BD iden= tifikuje modifikovan=C3=A9 riadky. Ak je v=C3=BDraz parametrizovan=C3=BD, t= ak k=C4=BE=C3=BA=C4=8Dov=C3=A9 slovo BINDIN a hodnoty para= metrov (structRowIdent alebo varIdent1, varIdent2, ...) s=C3=BA povinn=C3=A9. |
varIdent1, varIdent2, ... |
in | zoznam objektov, kon=C5=A1t=C3=A1nt alebo lok=C3=A1lnych premenn=C3=BD= ch, ktor=C3=A9 =C5=A1pecifikuj=C3=BA hodnoty parametrov parametrizovan=C3=A9ho SQ= L v=C3=BDrazu strExpression_Str. |
structRowIdent | in | Odkaz na riadok lok=C3=A1lnej premennej typu Record a= lebo na riadok =C5=A1t= rukt=C3=BArovanej premennej. Hodnoty riadkov =C5=A1pecifikuj=C3=BA hodn= oty parametrov paramet= rizovan=C3=A9ho SQL v=C3=BDrazu strExpression_Str. |
transHandle_Int | in | Identifik=C3=A1tor Pripojenia na datab=C3=A1zu. |
hintIdent_Str | in | V=C3=BDraz typu String, ktor=C3=BD defi=
nuje Oracle SQL hint. Ten je pou=C5=BEit=C3=BD ako in=C5=A1trukcia pre opti=
maliz=C3=A1tor v=C3=BDkonu SQL pr=C3=ADkazu. Zapisuje hodnotu bez oba=C4=BE=
uj=C3=BAcich znakov /*+ <orahint> */. Pr=C3=ADklad pou=C5=BEitia je uveden=C3=BD tu. |
Datab=C3=A1za mus=C3=AD by=C5=A5 otvoren=C3=A1 s pr=C3=ADstupom _DB_= MODIFY. Podobne ako pri akcii = DB_READ ( DBS_READ), m=C3= =B4=C5=BEu by=C5=A5 modifikovan=C3=A9 riadky ur=C4=8Den=C3=A9 dvoma sp=C3= =B4sobmi:
rowIdent
), resp. v celej =C5=A1trukt=C3=BAre (strExpression_Str
, ktor=C3=BD predsta=
vuje klauzulu WHERE pre SQL pr=C3=ADkaz UPDATE, ktor=C3=BD vykon=C3=A1va zmenu datab=C3=A1zy. V tomto pr=C3=ADpade j=
e hodnota k=C4=BE=C3=BA=C4=8Dovej polo=C5=BEky v =C5=A1trukt=C3=BAre nepou=
=C5=BEit=C3=A1.
V=C3=BDhodou akcie DBS_UPDATE pri pr=C3=A1ci s tabu=C4=BE=
kou je mo=C5=BEnos=C5=A5 vynecha=C5=A5 jej otvorenie a zatvorenie (jednoduc=
h=C5=A1=C3=AD z=C3=A1pis).
Pre D2000 verziu 5: Nev=
=C3=BDhoda akcie DBS_UPDATE je v r=C3=BDchlosti. Ka=C5=BEd=
=C3=A9 volanie akcie DBS_UPDATE m=C3=A1 za n=C3=A1sledok, =
v r=C3=A1mci jej obsluhy v procese D2000 DBManager, nutnos=C5=A5 datab=C3=A1zu otvori=C5=A5 a n=
=C3=A1sledne zatvori=C5=A5, =C4=8Do m=C3=B4=C5=BEe by=C5=A5 =C4=8Dasovo n=
=C3=A1ro=C4=8Dn=C3=A1 =C4=8Dinnos=C5=A5 a predstavuje z datab=C3=A1zov=C3=
=A9ho h=C4=BEadiska pomerne ne=C5=A1tandardn=C3=BD postup. Nutnos=C5=A5 otv=
=C3=A1rania a zatv=C3=A1rania datab=C3=A1zy je mo=C5=BEn=C3=A9 potla=C4=8Di=
=C5=A5 v r=C3=A1mci transak=C4=8Dn=C3=A9ho spracovania tak, =C5=BEe za pr=
=C3=ADkaz uvedieme parameter TRANS.
Pre D2000 v=
erziu 6 a vy=C5=A1=C5=A1ie: =
Optimaliz=C3=A1cia procesu D2000 DBManager (recyklovanie spojen=C3=AD, predpripraven=C3=A9 sp=
ojenia) sp=C3=B4sobila, =C5=BEe akcia DBS_UPDATE sa vykon=
=C3=A1 rovnako r=C3=BDchlo ako akcia DB_UPDATE a navy=C5=
=A1e sa u=C5=A1etr=C3=AD =C4=8Das potrebn=C3=BD na spracovanie explicitn=C3=
=A9ho pr=C3=ADkazu na otvorenie datab=C3=A1zy DB_CONNECT.<=
/p>
Potreba otvorenia a zatvorenia datab=C3=A1zy sa m=C3=B4=C5=BEe eliminova=
=C5=A5 v r=C3=A1mci transak=C4=8Dn=C3=A9ho spracovania tak, =C5=BEe za pr=
=C3=ADkazom nasleduje parameter TRANS.
S=C3=BAvisiace str=C3=A1nky: