E

Eclipse, 45, 84

ELSE, CASE expressions and, 295

Embedded SQL, 9, 47, 54, 256, 257, 585, 477

ENABLE QUERY OPTIMIZATION, 407

Encryption, 12, 50, 100, 155

authentication and, 100, 101, 102, 155

DATA_ENCRYPT, 101, 155, 573, 581

DATA_ENCRYPT_CMP, 101, 155, 573

GSS_Server_Encrypt and, 101, 155, 573

KRB_Server_Encrypt and, 100, 155, 573

Server_Encrypt and, 100, 155, 573, 581

End button, in IBM Certification exam, 30, 30

End Users, authorities and privileges using, 150t

Enterprise Developer's Edition, DB2, 36, 48–49

Enterprise Server Edition (ESE), 36, 42–45, 92, 567, 568

Advanced Access Control Feature in, 44

Application Requestor (AR) and Application Server (AS) in, 43, 568

Data Stream Engine and, 45

Database Partitioning Feature (DPF) in, 44

Geodetic Data Management in, 44

Label Based Access Control (LBAC) in, 44

Real-Time Insight feature in, 45

Storage Optimization Feature in, 44

Environment variables, DB2

INSTANCE as, 163

Environmental Systems Research Institute (ESRI), 58

Equal to, 272–274. See also comparison operators; relational predicates

Error logs, 9

Escalation of locks, 490–491, 491

Event monitors, 4, 73

Event, trigger, 220, 438, 441

Everyplace, DB2, 36, 60, 567

Exam objectives, 17

Exam results panel, in IBM Certification exam, 32, 32

EXCEPT set operator, 311–312, 311, 312, 590

Exception handling, 9

EXCLUSIVE, 612

Exclusive (X) lock, 482t, 484, 485, 486t, 488t, 489, 493, 495, 499, 500, 610

Executable objects, 246

EXECUTE, 120–121, 132, 133, 141, 142, 143, 149t, 157, 160, 171, 576, 579

RESTRICT clause and, 142

EXECUTE WITH GRANT, 171

EXISTS predicate, SELECT and, 279

Explain tables, 71. See also Visual Explain

Explicit granting of authorities/privileges, 124, 125

EXPORT utility, 4, 14, 117, 156, 576

Express, DB2, 36, 38–40, 92, 567

APPC support in, 40

Connection Concentrator in, 39

Global Secure Toolkit in, 40

Governor, DB2, in, 39

High Availability Disaster Recovery (HADR) in, 38–39

High Availability Feature in, 38

Homogeneous Federation Feature in, 39–40

Informix Data Source support in, 40

materialized query tables (MQTs), 9, 14, 39, 43, 80, 81, 197, 568, 585

Microsoft Cluster Server support in, 40

multidimensional clustering (MDC) in, 12, 39, 80, 81, 437–438, 568

NetBios support in, 40

On-Line Analytical Processing (OLAP) in, 35, 39

Online Reorganization in, 38–39

Performance Optimization feature in, 39

pureXML in, 38

Query Parallelism in, 39

Query Patroller (QP) in, 39

Replication Data Capture in, 40

Spatial Extender Client in, 40, 55, 58, 91, 95–96, 572

Tivoli System Automation for Multiplatforms (TSA MP) in, 39

Web Tools (DB2) in, 40

Workload Management Feature in, 39

Express-C, DB2, 36, 40, 568

Extenders, 35, 47, 55–59, 90, 95–96, 572

data types and, 366, 373

Extents, 174, 437

External routines, 586

External scalar functions, 229, 330

External stored procedures, 231, 233–240. See also stored procedures

External table functions, 229, 330

Extraction-Transform-Load (ETL) operations, 112