W


Waits, on locks, 492. See also locktimeout

Warehousing Dataflow Operators, 14

Warehousing Tool, SQL, 14, 46

Warehousing. See data warehousing

Warning dialog for end of exam, in IBM Certification exam, 30, 30

Weak exclusive (WE) lock, 482t, 486t, 488t

Web browsers, 51

Web clients, 13

Web Tools (DB2), 40

WebSphere Application Server, 46

WebSphere MQ, 54

WHENEVER, stored procedures and, 236

WHERE clause, 587, 588, 592

DELETE and, 264, 265

SELECT and, 268, 271, 272

UPDATE and, 262, 263

XQuery and, 337

WHERE CURRENT OF clause, 315

Wildcard characters, SELECT and, 276–277

Windows, 8, 11, 36, 40, 41, 42, 47, 49, 53, 54, 567, 568, 573

authentication and, 98, 100, 102, 155

Database Connection Services (DCS) directory in, 181–182, 249

privileges and, 119, 133, 135, 145

WITH CASCADED CHECK OPTION, 208, 209, 434, 584

WITH CHECK OPTION, 602

WITH DEFAULT, 260

WITH GRANT OPTION, 124, 128, 147t, 576, 580

WITH HOLD option, 316–317, 362, 597–598

WITH keyword, SELECT and, 291

WITH LOCAL CHECK OPTION, 433, 434, 460, 607

WITH RELEASE option, 320

WITH RETURN FOR clause, stored procedures and, 233

WITH RETURN option, 317

Workgroup Server Edition (WSE), DB2, 36, 41–42, 41, 567

Workload Management Feature, 39, 42

Workload. See database workload management

Workstations. See servers

World Wide Web Consortium (W3C), 335




DB2 9 Fundamentals Certification Study Guide
DB2 9 Fundamentals: Certification Study Guide
ISBN: 1583470727
EAN: 2147483647
Year: 2007
Pages: 93

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net