Copyright

Library of Congress Catologing-in-Publication Data

Lumbley, Joe

Informix DBA survival guide.—2nd ed./Joe Lumbley

p. cm. --(Prentice Hall PTR Informix series) Includes index.

ISBN 0-13-079623-9

1. Relational database. 2. Informix-SQL. I. Title.

II. Series.

QA76.9.D3L859 1999 98-44764

005.75'65--dc21 CIP

Credits

Editorial/Production Supervision:

Kerry Reardon

Acquisitions Editor:

Miles Williams

Buyer:

Alexis R. Heydt

Cover Design:

Design Source

Cover Design Direction:

Jerr0y Votta

Art Director:

Gail Cocker-Bogusz

Series Design:

Claudia Durrell Design

Marketing Manager:

Dan Rush

Manager, Informix Press:

Sandy Emerson

Informix Press

Informix Software, Inc.

4100 Bohannon Drive

Menlo Park, CA 94025

© 1995, 1999 Prentice Hall PTR Prentice-Hall, Inc.

A Simon & Schuster Company

Upper Saddle River, NJ 07458

The following are worldwide trademarks of Informix Software, Inc., or its subsidiaries, registered in the United States of America as indicated by ®, and in numerous other counties worldwide: INFORMIX®, Informix DataBlade® Module, Informix Dynamic Scalable Architecture™, Informix Illustra ™ Server, InformixLink®, 1NFORMIX®-4GL, INFORMIX®-4GL Compiled, INFORMIX®-CLI, INFORMIX®-Connect, INFORMIX®-ESQL/C, INFORMIX®-MetaCube™, INFORMIX®-Mobile, INFORMIX®-NET, INFORMlX®-NewEra™ INFORMIX®-NewEra™ Viewpoint™, INFORMIX®-NewEra™ Viewpoint™ Pro, INFORMIX®-OnLine, INFORMIX®-OnLine Dynamic Server™, INFORMIX®-OnLine Workgroup Server, INFORMIX®-OnLine Workstation, INFORMIX®-SE, INFORMIX®-SQL, INFORMlX-Superview™, INFORMIX®-Universal Server

All other product names mentioned herein are the trademarks or registered trademarks of their respective owners.

The publisher offers discounts on this book when ordered in bulk quantities. For more information, call the Corporate Sales Department at 800-382-3419; FAX: 201-236-714, email [email protected] or write Corporate Sales Department, Prentice Hall PTR, One Lake Street, Upper Saddle River, NJ 07458

Prentice Hall books are widely used by corporations and government agencies for training, marketing, and resale.

All rights reserved. No part of this book may be reproduced, in any form or by any means, without permission in writing from the publisher

Printed in the United States of America

10 9 8 7 6 5 4 3 2

Prentice-Hall International (UK) Limited, London

Prentice-Hall of Australia Pty. Limited, Sydney

Prentice-Hall Canada Inc., Toronto

Prentice-Hall Hispanoamericana, S.A., Mexico

Prentice-Hall of India Private Limited, New Delh

Prentice-Hall of Japan, Inc., Tokyo

Simon & Schuster Asia Pte. Ltd., Singapore

Editora Prentice-Hall do Brasil, Ltda., Rio de Janeiro