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