Download Creating User-Defined Routines and User-Defined Data

A
B
C
D
E
F
G
H
syscasts system catalog table 7-5,
7-12, 9-15, 9-27
syscolumns system catalog
table 13-6
sysindices system catalog
table 13-6
syslangauth system catalog
table 2-5
sysopclasses system catalog
table 11-20
sysprocauth system catalog
table 2-5, 4-17, 9-26, 10-7, 12-4,
13-38
sysprocbody system catalog
table 2-5, 3-8, 4-17, 4-25, 13-38
sysprocedures system catalog
table 10-6
cached in memory 13-36
candidate routines 3-17
columns of 4-24
contents of 13-37
description 2-5, 9-27
I/O considerations 13-38
path column 3-9, 12-10
UDR information 4-17
sysprocplan system catalog
table 4-17, 4-25, 13-5, 13-7, 13-38
sysroutinelangs system catalog
table 2-5
systables system catalog table 13-6
System catalog table
isolating 13-38
sysams 11-19
syscasts 7-5, 9-15
syscolumns 13-6
sysindices 13-6
syslangauth 2-5
sysprocauth 2-5, 4-17, 10-7, 12-4,
13-38
sysprocbody 3-8, 4-17, 4-25, 13-38
sysprocedures 2-5, 4-17, 13-37
sysprocplan 4-17, 4-25, 13-5, 13-7,
13-38
sysroutinelangs 2-5
systables 13-6
systrigbody 13-38
systriggers 13-38
sysxtdtypeauth 5-9, 9-17
sysxtdtypes 5-9, 9-14
8
I
J
K
L
M
N
O
P
Q
R
System requirements
database Intro-4
software Intro-4
systrigbody system catalog
table 13-38
systriggers system catalog
table 13-38
sysxtdtypeauth system catalog
table 5-9, 9-17, 9-26
sysxtdtypes system catalog
table 5-9, 9-14, 9-27, 10-7
T
Text operator
description of 6-5
for an opaque type 9-19
Thread
definition 13-16
insert 13-26, 13-28
join 13-25
primary 13-33
scan 13-24, 13-26, 13-33
secondary 13-33
sort 13-29
sqlexec 13-33
Thread-safe UDRs 13-30
times() function 6-4
Tip icons Intro-7
Transport functions 10-13
Triggered action statements 2-19
Type hierarchy 3-13, 3-18, 3-22
Type inheritance 3-22
U
UDR. See User-defined routine.
UNIX operating system, default
locale for Intro-4
Unnamed row type, aggregates 8-7
UPDATE STATISTICS
statement 3-15, 13-6
update() support function 10-22,
10-24, 10-27
User state, SPL routine 3-8
Creating User-Defined Routines and User-Defined Data Types
S
T
U
V
W
X
Y
Z
@
User-defined aggregate
definition of 2-11, 8-3
dropping 8-19
parallel execution 13-23, 13-27
User-defined cast
cast function 7-8
creating 7-5
definition of 7-4
dropping 7-12
implicit 7-6
kinds of 7-6
straight 7-8
See also Cast.
User-defined function
cursor 4-10
definition of 2-3
invoking in an expression 3-5
invoking with CALL 3-6
iterator 4-10
negator 13-15
noncursor 4-10
nonvariant 4-7
OUT parameter 4-8
variant 4-7
See also User-defined routine.
User-defined procedure 2-3
invoking with CALL 3-6
registering 4-14
See also User-defined routine.
User-defined routine (UDR)
altering 12-11
argument. See Routine argument.
assigning privileges to 4-15
choosing a VP class 13-17
coding standards for 4-12
database-level privileges 4-15
DBA tasks on 3-13
default VP class 13-18
description 1-3
designing 4-3
dropping 4-16, 12-11
enabling parallel execution 13-31
executing 3-6, 3-11, 13-21
invoking 3-3
loading 3-9
location of 4-24
managing 12-3
memory considerations 13-34
modal 4-5