Fujitsu UDS/SQL V2.5 User Manual
Glossary
P
U929-J-Z125-9-76
287
D
ok
us
c
h
abl
on
en
1
9x
24 V
e
rs
ion
7
.3
us
f
ü
r F
ram
eM
ak
er
V
7
.x
v
o
m
1
4.
02
.2
00
7
©
c
o
gni
tas
Gm
b
H
20
01-
20
07
18.
Ok
to
be
r 200
7 S
ta
nd 1
1:
29.
52
P
fad
: G:
\v
og
t\
fs
c
\uds
\M
anu
al
e\
en
\uds
en
t_
e\
ud
s
e
nt
.m
ix
PETA
Preliminary end of transaction: UDS-D or openUTM-D statement that causes a
preliminary transaction end.
The PETA statement belongs to the first phase of the two-phase commit protocol
which terminates a distributed transaction.
The PETA statement stores the following information failproof in the RLOG file
of the local DBH:
–
preliminary transaction end.
The PETA statement belongs to the first phase of the two-phase commit protocol
which terminates a distributed transaction.
The PETA statement stores the following information failproof in the RLOG file
of the local DBH:
–
each updated page
–
rollback and locking information
–
the names of all participating configurations.
This information is required for any future warm start.
pointer array
Table of pointers to the member records of a set occurrence. Used for sequential and
direct access
direct access
to member records.
prepared to commit (PTC)
Part of the two-phase commit protocol:
State of a subtransaction after execution of a PETA statement and before receipt
of the message that the complete transaction is to be terminated with FINISH or
FINISH WITH CANCEL.
State of a subtransaction after execution of a PETA statement and before receipt
of the message that the complete transaction is to be terminated with FINISH or
FINISH WITH CANCEL.
primary key
Distinguished from secondary keys for reasons of efficiency. Usually a unique
identifier for a record.
identifier for a record.
primary key (DDL)
The key of a record type which is defined by means of "LOCATION MODE IS
CALC" or the key of an order-determining key of a set occurrence which is
defined by means of "ORDER IS SORTED [ INDEXED]". Also used for direct
access
CALC" or the key of an order-determining key of a set occurrence which is
defined by means of "ORDER IS SORTED [ INDEXED]". Also used for direct
access
to a record or a set of records with the same key values or within a search
interval.
primary key (SQL)
In the broader sense (SQL), a record element uniquely identifying a record.
In UDS-SQL, the database key of an owner record output as the "PRIMARY
KEY" in the BPSQLSIA log (see also foreign key).
A record element which uniquely identifies a record is flagged as "UNIQUE" in the
BPSQLSIA log unless it is the aforementioned "PRIMARY KEY".
In UDS-SQL, the database key of an owner record output as the "PRIMARY
KEY" in the BPSQLSIA log (see also foreign key).
A record element which uniquely identifies a record is flagged as "UNIQUE" in the
BPSQLSIA log unless it is the aforementioned "PRIMARY KEY".