IBM DB2 9.7
for Linux, UNIX, and Windows
JOoOMw{}]bT\
2010 j 9 B|B
V9R7
S151-1164-02
IBM DB2 9.7
for Linux, UNIX, and Windows
JOoOMw{}]bT\
2010 j 9 B|B
V9R7
S151-1164-02
"b
9CKE"0d'VDz70,kHDAZ 515 3D=< B, :yw;BD#fE"#
^)fyw
KD5|, IBM DyP(E"#|ZmI-iPa),R\f((D#$#>vfoP|,DE";|(TNNz7D
#$,Ra)DNNod<;h*gKbM#
zIZ_r(}1XD IBM zm&): IBM vfo#
v *Z_):
vfo,k*A IBM vfoPD,x7*:www.ibm.com/shop/publications/order
v *iR1XD IBM zm&,k*A IBM +r*5K?<,x7*:www.ibm.com/planetwide
*S@zrSCsD DB2 P!Mz[?): DB2 vfo,kBg 1-800-IBM-4YOU(426-4968)#
1zr IBM "ME"1,4,bZh IBM @;^~D(&T
|O*J1R;aTzlINN0lD==9CrV"C
E"#
© Copyright IBM Corporation 2006, 2010.
?<
XZ>i ..............vii
>iDa9 ..............vii
Z 1 ?V T\Ev .........1
Z 1 B T\w{$_M=( ......3
y<LrbT ..............3
y<Lr<8 .............3
y<LrbT4(............5
y<LrbT4P............6
y<LrbTVv>} ..........7
Z 2 B T\`S$_M=( ......9
T53T\xPKw`S ..........9
53T\`S*XDy>/O .......10
`S}]PDl#5 ..........13
GOVERNOR 5CLr ...........13
t/M#9XFw ...........14
XFwX$Lr ............14
XFwdCD~ ............15
XFwfrSd ............18
XFwU>D~ ............22
#9XFw .............25
Z 3 B 0lT\DrX........27
53e5a9 ..............27
DB2 e5a9MxLEv .........27
DB2 xL<u#M ...........28
}]bzmLr ............32
xPdCT5V<CDT\ .........41
5}dC ...............47
mUdhF ..............47
ELf"wT\rX ..........47
mUdTi/E/D0l .........48
}]bhF ..............50
m ................50
w} ................54
Vxk/: .............64
*O}]b
.............71
J4{CJ ..............71
ZfVd ..............71
Tw{Zf&\Ev ..........77
:eX\m .............83
u<C',S=8PD}]b#CP* ....95
w{ErT\ .............96
}]i/ ...............97
mXi ...............98
w}Xi ..............106
7(N1XimMw} .........109
XimMw}DI> ..........111
uYXimMw}Dh*.........112
T/X
i ..............113
&CLrhF .............114
&CLrxL""PTkV4 .......114
"PTJb .............116
`4Mw{i/TcnsLHXa_T\ ...127
a_ekT\ ............136
_'D SELECT od..........137
PX^F SELECT odD<r.......138
8(PViT5M*z .........140
i/PD}]Iy ...........142
&CLrD"P&m ..........142
x(\
m ...............143
x(k"PTXF ...........143
x(#H ..............144
x(tT ..............145
0lx(DrX............146
x(`Mf]T............147
B;|x( .............148
j<mDx(==MCJ=8 .......148
MDC mM RID w}(hDx(== ....152
MDC iw}(hDx(== .......155
TVxmDx(P* ..........158
x(*; ..............160
x(H}
M,1............161
@x ...............162
i/E/ ...............163
SQL M XQuery `kw}L .......163
}]CJ=( ............183
,S ...............190
ErMViTi/E/D0l .......204
E/_T ..............205
9C_e/i/mDxi/E/ ......214
5w$_ ..............216
E/i/CJ=8 ...........254
3FS< ..............313
?<3FE" ............319
nsLHXua RUNSTATS D0l .....356
}]9ukT\.............357
5MU>G<*zTa_ DML T\ ......358
1Sek LOB ITa_T\ ........359
Z 4 B F(T\w{_T ......361
hFKJLr .............361
9ChFKJLr ...........364
*hFKJLr(e$w:X .......364
9ChFKJLr+%Vx}]b*;*`Vx}
]b ...............365
hFKJLrDV^TM^F .......365
Z 2 ?V TJbxPJOoO ...367
© Copyright IBM Corp. 2006, 2010 iii