Index Numerics 00C900A3 207 00C900D0 207 00C900Dx 246 -423 140 -857 33 -904 203 BLOB_FILE 18 BLOBs 11­12, 34, 55, 90, 110­112, 122, 128 BP40. 146 BPOOL 218 buffer pools 24, 35, 57­58, 125, 146, 149, 240, 244, 247 C Call Level Interface 81 CARDF 217­218 CAST 11, 73­74 CCSID 11, 19, 21, 28, 34, 55­56, 86, 148, 162, 166, 174, 214, 240, 243 Character Large Objects 10 check constraints 36, 41, 62 CHECK DATA xix, 7, 125, 198, 201, 259 CHECK DATA SHRLEVEL CHANGE 204 CHECK INDEX 209 CHECK INDEX SHRLEVEL CHANGE 209 CHECK INDEX SHRLEVEL REFERENCE 209 CHECK LOB 206 CHECK LOB SHRLEVEL CHANGE 207 CHECK LOB SHRLEVEL REFERENCE 207 CHECK LOB sort 6 check pending 198 CHECK-pending 206, 209 CHKP 198 choosing a page size 58 chunk 63­65, 80, 114, 119, 135, 193 chunking 144 CLI 81 CLOB 10­11, 17­19, 24­25, 32­33, 35, 56, 68, 73­74, 86, 89­90, 109, 111, 116, 122­123, 128, 131, 138, 143, 147, 166, 173­174, 216, 220, 261­262 CLOB_FILE 18 codepage 149 COLNAME 215 COLTYPE 32, 216 compression 28, 35, 62, 149, 244 CONCAT 72, 75, 80, 91, 93, 123­124 CONCURRENT copy 180­182 COPY 48, 50, 52, 102, 105, 141, 148, 162­163, 165, 168, 214­215, 220­221 COPY NO 31 COPYDDN 175, 179, 181­182, 187, 191 COPYLASTTIME 220 COPYTOCOPY 182­183 COPYUPDATEDPAGES 221 creating a LOB table space 35 creating a new table with ROWID 41 creating auxiliary table 35 creating LOBs 37 DDL statement 32 CREATOR 218 Cross Loader xix, 5, 85, 87, 96, 173­174, 178 A ABAP 128­131 ABAP reports 133­134 ACHKP 198, 202, 231 adding a LOB column 38­39 adding a ROWID 43 Advanced Business Application Programming 128, 131 Altering table 213 APIs 20 application programming xix, 2, 109, 128 ASCII 34, 55­56, 86, 149, 166, 174 Automatic creation of objects xix, 6, 24­26, 29, 184, 219 autorel duration 104 aux table 185 AUX WARNING state 51, 229, 233 AUXERROR 203 AUXERROR INVALIDATE 203­204 AUXERROR REPORT 203­204 auxiliary check pending 198­199 auxiliary check pending state 202 auxiliary column 13, 40 auxiliary index 14, 24­26, 29­31, 34­37, 40, 105, 150, 179­180, 187­188, 197, 218, 261­262 DDL 37 auxiliary LOB table 40 auxiliary table 12­15, 24, 39­40, 62, 71, 73­74, 85, 89, 92, 98, 107, 145, 152, 215­218, 220, 254­255, 261­262 auxiliary warning 198 auxiliary warning state 202 AUXONLY 203 AUXTBNAME 215 AUXTBOWNER 215, 219 AUXW 48, 51, 198, 202 AVGSIZE 216­217 B backup and recovery 213 base table 12­15, 24, 32, 39­40, 45, 62, 71, 73­74, 85, 89, 92, 97­98, 145, 158, 162, 214­218, 261­262 base table locks 97 Binary Large Objects 10 BIT 11, 34, 41, 55­56, 121, 133, 244, 256 BLOB 2, 10­11, 17­20, 24­25, 32­33, 35, 38, 62, 68, 73, 81, 109­110, 116, 119, 121, 123, 128, 130­131, 144, 147­148, 162­163, 165, 214, 216, 219­220, 261­262 © Copyright IBM Corp. 2006. All rights reserved. 273