Copyright

Library of Congress Cataloging-in-Publication Data

Flannery, Ron.

The Informix handbook / Ron Flannery.

p. cm.

ISBN 0-13-012247-5

1. INFORMIX (Computer program language) I. Title.

QA76.73.I22 F53 2000

005.75'65--dc21 00-026324

Credits

Editorial/Production Supervision: Patti Guerrieri

Acquisitions Editor: Miles Williams

Marketing Manager: Kate Hargett

Editorial Assistant: Michael Fredette

Buyer: Alexis Heydt

Cover Design Direction: Jerry Votta

Art Director: Gail Cocker-Bogusz

Series Design: Maureen Eide

Manager, Informix Press: Judy Bowman

Informix Press

Informix Software, Inc.

4100 Bohannon Drive

Menlo Park, CA 94025

http://www.informix.com/ipress

ipress@informix.com

© 2000 Prentice Hall PTR

Prentice-Hall, Inc.

Upper Saddle River, NJ 07458

The publisher offers discounts on this book when ordered in bulk quantities.

For more information, contact: Corporate Sales Department, Phone: 800-382-3419;

Fax: 201-236-7141; E-mail: corpsales@prenhall.com; or write: Prentice Hall PTR,

Corp. Sales Dept., One Lake Street, Upper Saddle River, NJ 07458.

The following are trademarks of Informix Corporation or its affliates, one or more of which may be registered in the U.S. or other jurisdications:Informix®, Answers OnLine, C-ISAM®, Centaur, Foundation.2000, i.Foundation, i.Intelligence, Informix®, Informix® 4GL, Informix® 4GL Compiler, Informix® 4GL Interactive Debugger, Informix® 4GL Rapid Development System, Informix® Assurance (Assurance), Informix® C-ISAM® DataBlade® module, Informix® CLI, Informix® Client SDK (Client SDK), Informix® Cloudscape (Cloudscape), Informix® COM Adapter, Informix® Connect, nformix® DataBlade® module, Informix® Data Director (Data Director),Informix® DCE/NET, Informix® Decision FastStart (Decision FastStart), Informix® Decision Frontier (Decision Frontier), Informix® Decision Solution Suite (Decision Solution Suite),Informix® Driver for JDBC, Informix® Dynamic Scalable Architecture (DSA), Informix® Dynamic Server, Informix® Dynamic Server.2000, Informix® Dynamic Server, Developer Edition, Informix® Dynamic Server with Advanced Decision Support Option, Informix® Dynamic Server with Extended Parallel Option, Informix® Dynamic Server with MetaCube® ROLAP Option, Informix® Dynamic Server with Universal Data Option, Informix® Dynamic Server with Web Integration Option, Informix® Dynamic Server, Workgroup Edition, Informix® Enterprise Command Center, Informix® Enterprise Gateway Manager (Enterprise Gateway Manager),Informix® Enterprise Gateway for EDA/SQL (Enterprise Gateway for EDA/ SQL), Informix® Enterprise Gateway with DRDA® (Enterprise Gateway with DRDA®), Informix® ESQL/C, Informix® Extended Parallel Server (Extended Parallel Server or XPS),Informix® i.Decide (i.Decide ), Informix® i.Reach (i.Reach ), Informix® i.Sell (i.Sell ), Informix® I-Spy (I-Spy ), Informix® Internet Foundation.2000, Informix® J/Foundation (J/Foundation), Informix® Media360 (Media360), Informix® MetaCube® (MetaCube®), Informix® MetaCube® Agents (MetaCube® Agents), Informix® MetaCube® Aggregator (MetaCube® Aggregator), Informix® MetaCube® Analysis Engine (MetaCube® >> >Analysis Engine), Informix® MetaCube® Explorer (MetaCube® Explorer), Informix® MetaCube® for Excel® (MetaCube® for Excel), Informix® MetaCube® for the Web (MetaCube® for the Web), Informix® MetaCube® Product Family (MetaCube®), Informix® MetaCube® QueryBack (MetaCube® QueryBack), Informix® MetaCube® Scheduler (MetaCube® Scheduler), Informix® MetaCube® Warehouse Manager (MetaCube® Warehouse Manager), Informix® MetaCube® Warehouse Optimizer (MetaCube® Warehouse Optimizer), Informix® NewEra® (NewEra®), Informix® Office Connect, Informix® OpenLine (OpenLine), Informix® Red Brick® and Design, Informix® Server Administrator (Server Administrator), Informix® SQL, Informix® Virtual Table Interface (Virtual Table Interface), Informix® Visionary (Visionary), ON-Bar, Regency Support®, RISQL®, Solutions Portal.

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 1

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 Delhi

Prentice-Hall of Japan, Inc., Tokyo

Pearson Education Asia Pte. Ltd.

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