C

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