C/C++, 40
stored procedures and, 233, 235, 238
C-API, 45
CALL, 331–332, 363, 598
Call Level Interface (CLI), 8, 9, 47, 54
Configuration Assistant in, 77–78, 78
isolation levels and, 476, 477
Cartesian products, 296, 587
Cascading, trigger, 225
CASE expressions, 291–295, 358, 593
ELSE and, 295
searched, 291–295
simple, 291–295
syntax of, 293
TRUE, FALSE and Unknown in, 295
Case sensitivity, in SELECT, 277
Casting data types, 9, 227–228
CATALOG, 585
CATALOG DATABASE, 179, 182–186, 581, 582, 585
CATALOG DCS DATABASE, 188–189
CATALOG…NODE commands, 186–188
Cataloging and uncataloging, 580–582, 585
Configuration Assistant and, 77–78, 78, 182, 186
databases, 182–186
DCS database, 188–189
node, 186–188
Certification Agreement, 34
Certification Exam tool, 17
Certification Navigator, 15, 16
Certification process, 15–34
arranging to take a certification exam in, 17–19
Certification Agreement and, 34
Certification Exam tool in, 17
Certification Navigator and, 15, 16
cost of exams and, 19
exam objectives in, 17
IBM Learning Services and, 15–17
online tutorials for, 16
processing of your certification in, 34
publications to prepare for, 16
retesting in, 34
sample questions/exams for, 17
taking the exam in, 19–34
Certification. See IBM DB2 9 certification
Chaining, 214
CHANGE ISOLATION, 477
Character large object (CLOB), 59, 200, 372, 455, 600, 601
DISTINCT clause in, 270
Character string (CHAR, CHARACTER) data types, 199, 368–370, 445, 600, 601
CHARACTER VARYING, 200
Check conditions, 378
CHECK constraint, 365, 374, 378–379, 379, 384, 400, 403, 406, 408, 410, 422, 424, 425, 457, 603–605
Check Pending state of tables, 399–401
CHECKDATA, 7
Child tables, 365, 382. See parent and child tables
CICS, 43, 54
CLI. See Call Level Interface
CLIENT, 573, 581
Client/server architectures, Developer Workbench in, 10, 83–84, 85, 89, 94, 569, 570
Clients, 13
authentication and, 100, 155
trusted vs. untrusted, 102–103
Clients, DB2, 13, 35, 51–54, 60
Client, 53–54
Runtime Client in, 51–53, 52
CLOBs. See Character large objects
CLOSE, cursors and, 320, 322
Cloudscape, 49
CLUSTER option, 437
Clustering, 79, 210, 211, 436–438
COBOL, 233
stored procedures and, 238
Code set, code point, code page, 173
Collating sequence, SQL and, 173
Columns, 203, 403–409, 445, 447, 608, 609
CHECK constraint, 365, 374, 378–379, 379, 384, 400, 403, 406, 408, 410, 422, 424, 425, 457, 603–605
constraints on, 403, 406, 408, 410, 421, 422, 424, 425, 426
CREATE TABLE for, 419–427
declared temporary tables and, 429–432
GENERATED …AS IDENTITY and, 411–413
identity type, 411–413
NOT NULL constraints in, 365, 374–375, 375, 384, 407, 419, 420, 423, 425, 426, 457, 601, 604
referential integrity constraints, 406–408
UNIQUE constraint, 365, 374, 379–381, 380, 384, 403, 406, 408, 410, 421, 426, 456, 457, 602, 605
XML data in, 372–373, 454, 461–462, 599–600, 599, 608, 609
Command Editor, 66–71, 67
Commands, Query, Results, and Access Plan pages in, 67, 70, 71
SQL and, 256
SQL Assist tool and, 66, 67–68, 68
Visual Explain in, 68–71, 69
Command Line Interface (CLI), 52
Command Line Processor (CLP), 60, 82–83, 83, 164, 240, 570
isolation levels and, 477
SQL and, 256
COMMIT, 6, 322–326, 323, 325, 361, 597
Common table expressions, 289–291, 360–361, 594
Common tasks and related authorities and privileges, 148, 148–149t
Communications protocols, 181
Comparison functions/operators
SELECT and, 272–274
user-defined data types and, 227
Compatibility, of locks, 487, 488t, 487, 500
Component Object Model (COM), user-defined functions and, 230, 330–331
Compound SQL, 10
Concurrency. See data concurrency
Configuration, 11
Configuration Advisor, 171
Configuration Assistant, 53, 77–78, 78, 93, 569, 582
cataloging and uncataloging via, 182, 186
Configuration files, SQL and, 170
CONNECT, 113, 127, 137, 149, 157, 171, 190–191, 567, 576, 577
Connect Personal Edition, 47
CONNECT RESET, 191
Connect Unlimited Edition for zSeries, DB2, 49
Connect, DB2, 43, 54–55
Application Server Edition of, 54–55
Connect Unlimited Edition of, 55
Dynamic Logical Partitioning in, 49
Enterprise Edition of, 54
Personal Edition of, 54
Version/Release naming in, 49
CONNECT_QUIESCE, 127, 137
Connection Concentrator, 39, 43
Connectivity, 12, 190–191, 576
authentication, passwords, user IDS in, 190, 191
Configuration Assistant in, 77–78, 78
CONNECT and, 113, 127, 137, 149, 157, 171, 190–191, 567, 576, 577
CONNECT RESET and, 191
Control Center and, 190
Database Connection Services (DCS) directory in, 181–182, 188–189, 249
implicit vs. explicitly connections in, 191
QUIESCE_CONNECT, 113
SQL and, 190–191, 243, 249
Consistency. See data consistency
Constraints, 3, 11, 50, 365, 374–401, 447, 456, 602–606
aliases and, 214
CHECK, 374, 378–379, 379, 384, 400, 403, 406, 408, 410, 422, 424, 425, 457
check conditions in, 378
Check Pending state of tables and, 399–401
columns and, 403, 406, 408, 410, 421, 422, 424, 425, 426
CREATE TABLE and, 419–427
default, 364, 374, 375–378, 376–377t, 378, 602, 605
ENABLE QUERY OPTIMIZATION and, 407
foreign key constraints and, 381
informational, 374, 397–398, 398, 605
NOT ENFORCED and, 407
NOT ENFORCED ENABLE QUERY OPTIMIZATION and, 397–398, 397
NOT NULL, 365, 374–375, 375, 384, 407, 419, 420, 423, 425, 426, 457, 601, 604
primary keys and, 381
referential integrity, 374, 381–397, 406–410, 499, 456, 459. See also referential integrity constraints, 381
table check, 378, 457
temporary suspension of, using SET INTEGRITY, 398–401
UNIQUE, 365, 374, 379–381, 380, 384, 403, 406, 408, 410, 421, 426, 456, 457, 602, 605
VALIDATED and, 410–411, 609
XML data columns and, 410–411
XMLVALIDATED() and, 410–411, 609
Container, 174–175
CONTROL, 116, 117, 118, 120, 122, 123, 124, 129, 130, 133, 134, 139, 140, 141, 143, 144, 156, 158, 159, 574, 575, 576, 577, 578, 580
authorities and privileges using, 147t
privileges and, 147t
Control Center, 4, 7, 49, 53, 61–64, 62, 63, 64, 176–177, 570, 582
aliases and, 215, 216
basic, advanced, and custom views in, 61–62
connectivity and, 190
Create Database Wizard and, 176–177, 177
deleting/dropping objects using, 241–242, 242
granting/revoking authorities and privileges through, 125–126, 125, 126
indexes and, 212, 213
Journal in, 75–76, 76
Legend dialog in, 63, 64
menu bar in, 62
objects, contents, and object details panes in, 63
schema creation using, 195–196, 195, 196
tables and, 201–202, 201, 202, 401
toolbar in, 62 63
triggers and, 223, 224
user-defined data types and, 226, 226, 227
views and, 205, 206
Control flows, 14
Control server, DB2, and satellites, 65–66
Conversion deadlock, 494
Conversion of locks, 489–490, 489, 500, 612
Cost of exams, 19
Create Alias dialog, 215, 216
CREATE ALIAS, 214–215
CREATE DATABASE, 165
Create Database Wizard, 165, 176–178, 177, 178
CREATE DATABASE, 171–176
CREATE DISTINCT TYPE, 225–226, 373, 587, 600
Create Distinct Type dialog, 226, 226, 227
CREATE_EXTERNAL_ROUTINE, 113, 127, 137, 149t
CREATE FUNCTION, 230
CREATE INDEX, 211–212, 212
t, 435–438, 582
Create Index wizard, 212, 213
CREATE_NOT_FENCED, 171
CREATE_NOT_FENCED_ROUTINE, 113–114, 127, 137
CREATE PROCEDURE, 231–233, 234–240, 331, 332
CREATE SCHEMA, 193–195
CREATE SEQUENCE, 218–220
CREATE_TAB, 149t
CREATETAB, 113, 127, 137, 157, 171, 574, 577
CREATE TABLE, 402, 198–201, 198–200t, 419–427, 446, 452, 456, 602, 610
data types used with, 404–405t
declared temporary tables and, 428
duplicate tables, 417
examples of, 419–427
identity columns and, 413
PARTITION BY clause for, 414–416
VALIDATED predicate and, 411
XML data columns and, 410–411
Create Table Wizard, 201–202, 201, 202, 401
CREATE TRIGGER, 120, 221–223, 223t, 576
Create Trigger dialog, 223, 224
CREATE TYPE, 228, 373
CREATE VIEW, 120, 204–205, 207, 432–434, 460, 576, 607
Create View dialog, 205, 206
CREATEIN privilege, 115, 128, 138–139, 149t, 156, 574
Creating database objects, 191–241. See also databases and database objects
Creating a database, 107. See also databases and database objects
Cube models, 13
CURRENT SCHEMA, 419, 606
CURRENT SQLID, 419
Cursor Stability isolation level, 468, 469, 472–473, 474, 476, 610, 612, 613
Cursors, 9, 314–322, 597–598
ambiguous, 315
CLOSE and, 320, 322
coding for, 321–322
Cursor Stability isolation level and, 468, 469, 472–473, 474, 476, 610, 612, 613
DECLARE CURSOR for, 315, 316–317, 322
FETCH and, 318, 319–320, 322
FOR FETCH ONLY clause and, 317
FOR READ ONLY clause and, 317
FOR UPDATE OF clause and, 317
OPEN statement and, 317–319, 322
positions of, Before, On, After last row of data, 319
read-only, 314–315
SQL Descriptor Area (SQLDA) data structure and, 318, 320
steps in incorporating/using, 315
updatable, 315
WHERE CURRENT OF clause and, 315
WITH HOLD option for, 316–317, 362
WITH RELEASE option in, 320
WITH RETURN option for, 317
CV Advisor, 13
CYCLE clause, identity columns, 413