Understanding DB2: Learning Visually with Examples (2nd Edition)

The authors and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programs contained herein.

© Copyright 2005 by International Business Machines Corporation. All rights reserved.

Note to U.S. Government Users: Documentation related to restricted right. Use, duplication, or disclosure is subject to restrictions set forth in GSA ADP Schedule Contract with IBM Corporation.

IBM Press Program Manager: Tara Woodman, Ellice Uffer

IBM Press Consulting Editor: Susan Visser

Cover design: IBM Corporation

Published by Pearson plc

Publishing as IBM Press

Library of Congress Cataloging-in-Publication Data

Understanding DB2® : learning visually with examples / Raul F. Chong ... [et al.].

    p. cm.

  Includes bibliographical references and index.  ISBN 0-13-185916-1 (hardcover : alk. paper)1. Relational databases. 2. IBM Database 2. I. Chong, Raul F.

  QA76.9.D3U55 2005

  005.75'65--dc22

                                                               2004028592

IBM Press offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include electronic versions and/or custom covers and content particular to your business, training goals, marketing focus, and branding interests. For more information, please contact:

U. S. Corporate and Government Sales

1-800-382-3419

corpsales@pearsontechgroup.com.

For sales outside the U. S., please contact:

International Sales

international@pearsoned.com.

The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: DB2, Lotus, Tivoli, WebSphere, Rational, IBM, the IBM logo, and IBM Press. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of the Microsoft Corporation in the United States, other countries, or both. Linux is a registered trademark of Linus Torvalds. Intel, Intel Inside (logo), MMX, and Pentium are trademarks of Intel Corporation in the United States, other countries, or both. OSF/1 and UNIX are registered trademarks and The Open Group is a trademark of the The Open Group in the United States and other countries. Other company, product, or service names mentioned herein may be trademarks or service marks their respective owners.

All rights reserved. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, write to:

Pearson Education, Inc.Rights and Contracts DepartmentOne Lake Street

Upper Saddle River, NJ 07458

Text printed in the United States on recycled paper at Courier in Westford, Massachusetts.

First printing, January 2005

Dedication

Raul would like to thank his parents, Elias and Olga Chong, for their support, love, and understanding; and to his siblings, Alberto, David, Patricia, and Nancy. Their examples of success and perseverance encouraged Raul to continue with the hard work of writing and completing this book.

Clara would like to thank her familyLouis, Christina, and Estherfor their endless love and support. Most of all, Clara wants to thank Heison for being patient and understanding when she spent numerous late nights and weekends writing this book.

Sylvia would like to thank her parents for their love and support throughout the years. And also to her husband, Michael, for his endless support, love, patience, and understanding.

Dwaine would like to thank Linda Snow and Alyssa Bergman for their support, love, and understanding during the hours that were spent writing this book.