Stimmen - 0, Durchschnittliche Bewertung: 0
(
)
)
|
Dieses Gerät hat auch andere Anweisungen:
Anleitung Zusammenfassung
When
the
T
urb oIMA
GE/XL
database
is
attached
to
the
DBEn
vironmen
t,
sev
eral
ev
en
ts
take
place:
1.
The
A
TCINF
O
( DBEnvir
onmentName
CR)
and
DBName
TC
les
are
created.
2.
Denitions
of
the
T
urb oIMA
GE/XL
mapp ed
tables
are
placed
in
the
system
catalog
of
the
DBEn
vironmen
t.
These
en
tries
in
the
system
catalog
iden
tify
the
tables
as
mapp ed
tables.
The
naming
con
v
en
tion
for
SQL
tables
is
OwnerName.T
ableName
.
By
default,
in
mapp ed
tables,
IMA
GE/SQL
sp ecies
the
database
name
as
the
o
wner
name
and
the
data
set
name
as
the
table
name.
Th
us,
the
naming
con
v
en
tion
for
mapp ed
tables
is
Mapp
e
dDatab
aseName.Mapp
e
dDataSetName
.
(A
t
attach
time,
y
ou
m
ust
substitute
a
dieren
t
o
wner
name
if
an
already
attached
database
has
the
same
name.)
3.
Denitions
of
the
T
urb oIMA
GE/XL
mapp ed
columns
are
placed
in
the
system
catalog
of
the
DBEn
vironmen
t.
4.
Denitions
for
hash
indices
on
T
urb oIMA
GE/XL
master
k
ey
item
and
detail
searc
h
items
are
en
tered
in
to
the
system
catalog
for
the
DBEn
vironmen
t.
All
master
k
eys,
except
P
and
Z
data
t
yp es,
are
en
tered
as
unique
hash
indices.
Denitions
for
detail
searc
h
items,
as
w
ell
as
master
P
and
Z
k
ey
t
yp es,
are
en
tered
as
non-unique
hash
indices.
These
denitions
are
in
the
views
SYSTEM.IMA
GEKEY
and
CA
T
ALOG.IMA
GEKEY.
With
the
hash
indices,
the
p erformance
at
run-time
is
m
uc
h
b etter
when
the
equality
op erator
is
used
with
the
SQL
statements.
If
the
B-T
ree
index
is
created
for
the
k
ey
item
of
a
master
data
set
using
T
urb oIMA
GE/XL,
a
denition
for
a
unique
B-T
ree
index
is
placed
in
the
system
catalog.
In
addition,
denitions
for
non-unique
B-T
ree
indices
for
all
of
the
searc
h
items
of
the
detail
data
sets
to
whic
h
this
k
ey
item
has
a
path
are
added
in
the
system
catalog.
The
denitions
for
these
B-T
ree
indices
are
in
the
views
SYSTEM.INDEX
and
CA
T
ALOG.INDEX
of
the
system
catalog.
5.
If
the
database
is
enabled
for
third-party
indexing,
denitions
for
these
indices
are
also
added
to
the
system
catalog
of
the
DBEn
vironmen
t,
except
for
k
eyw
ord
indices
and
those
indices
for
whic
h
the
third-party
pro
vides
no
information.
These
denitions
may
b e
for
unique
or
non-unique
indices.
The
denitions
are
in
the
views
SYSTEM.TPINDEX
and
CA
T
ALOG.TPINDEX
of
the
system
catalog.
The
denitions
for
third-party
indices
are
also
placed
in
the
system
catalogs
of
other
DBEn
vironmen
ts
to
whic
h
the
database
is
attached.
6.
The
T
urb oIMA
GE/XL
database
creator
(DBC)
is
dened
in
the
A
TCINF
O
le
as
an
IMA
GE/SQL
user.
F
or
securit
y
reasons,
all
other
IMA
GE/SQL
users
m
ust
b e
explicitly
added
b
y
the
DBC.
Figure
3-3
sho
ws
an
attached
database.
3-4
Understanding
IMA
GE/SQL
...Dieses Handbuch ist für folgende Modelle:
Software - MPE/iX 6.5 Operating System (568.35 kb)
Software - MPE/iX 7.0 Operating System (568.35 kb)
Software - MPE/iX 7.5 Operating System (568.35 kb)