A Complete Guide to DB2 Universal DatabaseMorgan Kaufmann, 1998 - 816 pages DB2 Universal Database (UDB) supports many different types of applications, on many different kinds of data, in many different software and hardware environments. This book provides a complete guide to DB2 UDB Version 5 in all its aspects, including the interfaces that support end users, application developers, and database administrators. It is complementary to the IBM product documentation, providing a clear and informal explanation of how the features of DB2 were intended to be used. It is an extensive revision of the author's earlier book, Using the New DB2: IBM's Object-Relational Database System. Features:
|
Contents
VI | 2 |
VII | 4 |
VIII | 5 |
IX | 7 |
XI | 8 |
XII | 12 |
XIII | 15 |
XIV | 17 |
CLX | 383 |
CLXI | 384 |
CLXII | 389 |
CLXIV | 390 |
CLXV | 391 |
CLXVII | 393 |
CLXIX | 394 |
CLXX | 395 |
XV | 18 |
XVI | 20 |
XVII | 22 |
XVIII | 23 |
XIX | 25 |
XX | 26 |
XXI | 27 |
XXII | 28 |
XXIII | 32 |
XXIV | 35 |
XXV | 36 |
XXVI | 39 |
XXVIII | 41 |
XXIX | 43 |
XXX | 44 |
XXXI | 48 |
XXXII | 49 |
XXXIII | 50 |
XXXIV | 56 |
XXXV | 58 |
XXXVI | 60 |
XXXVII | 62 |
XXXVIII | 65 |
XXXIX | 69 |
XL | 71 |
XLI | 73 |
XLII | 74 |
XLIV | 76 |
XLV | 78 |
XLVI | 80 |
XLVII | 81 |
XLVIII | 82 |
XLIX | 83 |
L | 84 |
LI | 86 |
LII | 91 |
LIII | 94 |
LIV | 95 |
LV | 97 |
LVI | 99 |
LVII | 103 |
LVIII | 109 |
LIX | 115 |
LX | 116 |
LXI | 118 |
LXIII | 120 |
LXVI | 122 |
LXVII | 125 |
LXVIII | 131 |
LXX | 132 |
LXXI | 136 |
LXXII | 137 |
LXXIII | 139 |
LXXIV | 141 |
LXXVI | 143 |
LXXVII | 145 |
LXXVIII | 146 |
LXXX | 147 |
LXXXII | 149 |
LXXXIV | 150 |
LXXXVI | 151 |
LXXXVII | 153 |
LXXXVIII | 155 |
LXXXIX | 157 |
XC | 160 |
XCI | 162 |
XCII | 165 |
XCIII | 166 |
XCIV | 167 |
XCV | 168 |
XCVI | 169 |
XCVII | 172 |
XCVIII | 173 |
XCIX | 175 |
C | 184 |
CI | 188 |
CII | 191 |
CIII | 195 |
CIV | 199 |
CVI | 200 |
CVII | 202 |
CVIII | 206 |
CIX | 207 |
CX | 208 |
CXI | 213 |
CXII | 215 |
CXIII | 219 |
CXIV | 221 |
CXV | 228 |
CXVI | 231 |
CXVII | 233 |
CXVIII | 238 |
CXIX | 243 |
CXX | 244 |
CXXI | 247 |
CXXII | 251 |
CXXIII | 254 |
CXXIV | 259 |
CXXV | 271 |
CXXVII | 272 |
CXXVIII | 274 |
CXXIX | 277 |
CXXX | 282 |
CXXXI | 287 |
CXXXII | 290 |
CXXXIII | 292 |
CXXXIV | 296 |
CXXXVI | 299 |
CXXXVII | 302 |
CXXXVIII | 303 |
CXXXIX | 306 |
CXL | 307 |
CXLI | 310 |
CXLIII | 313 |
CXLIV | 319 |
CXLV | 328 |
CXLVI | 331 |
CXLVII | 341 |
CXLVIII | 343 |
CXLIX | 349 |
CL | 358 |
CLI | 365 |
CLII | 367 |
CLIII | 369 |
CLIV | 370 |
CLV | 372 |
CLVI | 373 |
CLVII | 380 |
CLVIII | 381 |
CLXXI | 400 |
CLXXIII | 401 |
CLXXIV | 408 |
CLXXV | 410 |
CLXXVI | 414 |
CLXXVII | 416 |
CLXXVIII | 417 |
CLXXIX | 418 |
CLXXX | 422 |
CLXXXI | 427 |
CLXXXII | 431 |
CLXXXIII | 432 |
CLXXXIV | 434 |
CLXXXV | 452 |
CLXXXVI | 453 |
CLXXXVII | 455 |
CLXXXVIII | 461 |
CXC | 462 |
CXCI | 464 |
CXCII | 465 |
CXCIII | 466 |
CXCIV | 471 |
CXCV | 472 |
CXCVI | 482 |
CXCVII | 498 |
CXCVIII | 502 |
CXCIX | 507 |
CC | 514 |
CCI | 519 |
CCII | 526 |
CCIII | 530 |
CCIV | 534 |
CCV | 539 |
CCVI | 551 |
CCVIII | 552 |
CCIX | 553 |
CCX | 558 |
CCXI | 559 |
CCXII | 565 |
CCXIII | 566 |
CCXIV | 567 |
CCXV | 572 |
CCXVI | 576 |
CCXVII | 579 |
CCXIX | 580 |
CCXX | 586 |
CCXXI | 587 |
CCXXII | 589 |
CCXXIII | 591 |
CCXXIV | 596 |
CCXXV | 599 |
CCXXVI | 603 |
CCXXVIII | 604 |
CCXXX | 607 |
CCXXXI | 608 |
CCXXXII | 613 |
CCXXXIII | 620 |
CCXXXIV | 624 |
CCXXXV | 625 |
CCXXXVI | 626 |
CCXXXVII | 627 |
CCXXXVIII | 628 |
CCXXXIX | 630 |
CCXL | 632 |
CCXLI | 633 |
CCXLII | 635 |
CCXLIII | 642 |
CCXLIV | 643 |
CCXLV | 644 |
CCXLVI | 645 |
CCXLVII | 646 |
CCXLVIII | 649 |
CCXLIX | 653 |
CCL | 656 |
CCLI | 659 |
CCLIII | 660 |
CCLIV | 662 |
CCLV | 667 |
CCLVI | 670 |
CCLVII | 674 |
CCLIX | 676 |
CCLX | 680 |
CCLXI | 683 |
CCLXIII | 687 |
CCLXIV | 688 |
CCLXV | 690 |
CCLXVI | 706 |
CCLXVII | 709 |
CCLXVIII | 713 |
CCLXIX | 714 |
CCLXXII | 715 |
CCLXXIV | 716 |
CCLXXV | 717 |
CCLXXVII | 718 |
CCLXXVIII | 720 |
CCLXXIX | 721 |
CCLXXX | 722 |
CCLXXXII | 724 |
CCLXXXIV | 725 |
CCLXXXV | 729 |
CCLXXXVII | 731 |
CCLXXXVIII | 732 |
CCXC | 733 |
CCXCI | 734 |
CCXCIII | 737 |
CCXCV | 739 |
CCXCVI | 740 |
CCXCVII | 741 |
CCXCVIII | 742 |
CCC | 743 |
CCCI | 744 |
CCCII | 747 |
CCCIII | 748 |
CCCIV | 749 |
CCCV | 750 |
CCCVII | 751 |
CCCVIII | 752 |
CCCX | 753 |
CCCXI | 754 |
CCCXII | 755 |
CCCXIII | 757 |
CCCXIV | 758 |
CCCXV | 759 |
CCCXVI | 761 |
CCCXVIII | 762 |
CCCXIX | 765 |
CCCXXI | 767 |
769 | |
Common terms and phrases
access plan application program argument backup bytes called catalog table char check constraint clause client Clob column names command configuration connection constraint contains Control Center CREATE TABLE cursor database administrator database system Decimal DECLARE SECTION default defined DELETE deptno described in Section descriptor distinct type dynamic SQL example EXEC SQL executed external function FETCH foreign key GROUP hdbc host variable indicator indicator variable input INSERT Integer interface invoke Java JDBC length locator node nodegroup null value object operators optimizer option package parameter markers partitioning partno precompiler primary key privilege query optimization recursive referential integrity result set rows schema name scratchpad SELECT server Smallint specify SQL statement SQLCA SQLCODE SQLDA SQLSTATE static SQL stored procedure strcpy string subquery syntax SYSFUN SYSIBM table function table named TABLE statement tablespace Timestamp tion transaction trigger UPDATE user-defined Varchar Vargraphic VisualAge
Popular passages
Page ii - Interfaces, & the Incremental Approach Michael L. Brodie and Michael Stonebraker Atomic Transactions Nancy Lynch, Michael Merritt, William Weihl, and Alan Fekete Query Processing for Advanced Database Systems Edited by Johann Christoph Freytag, David Maier, and Gottfried Vossen Transaction Processing: Concepts and Techniques Jim Gray and Andreas Reuter Understanding the New SQL: A Complete Guide Jim Melton and Alan R.
Page ii - Advanced Database Systems Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T. Snodgrass, VS Subrahmanian, and Roberto Zicari Principles of Transaction Processing Philip A. Bernstein and Eric Newcomer Using the New DB2: IBM's ObjectRelational Database System Don Chamberlin Distributed Algorithms Nancy A.