Programming Informix SQL/4GL: A Step-By-Step Approach (Bk/CD) (2nd Edition) - Softcover

Kipp, Cathy

Softcover

ISBN 10: 013675919X ISBN 13: 9780136759195

Publisher: Prentice Hall Ptr, 1997

Synopsis

An indispensable tutorial and reference in one volume, this second edition has been revised and updated based on end-user feedback and changes in the Informix SQL/4GL languages. The CD-ROM contains many helpful software packages and hundreds of examples that help readers understand Informix 4GL and Informix SQL.

About this title

About the Author

CATHY KIPP is the principal consultant at Database Strategies, Inc., a company specializing in Informix database products. She is President of the Informix User Group of Colorado and President and a founding member of the International Informix User Group.

From the Back Cover

The up-to-date primer for every INFORMIX SQL/4GL database developer! This example-rich primer covers everything you need to know to successfully design, implement, and maintain databases with Informix's version of SQL.

You'll quickly review the basics of database design, with easy-to-understand explanations of normalization, indexing strategies, and more. Then discover the SQL working environment, DB-Access, and the unique capabilities and features of Informix's SQL implementation; and how INFORMIX-SE and INFORMIX-OnLine compare. Walk step by step through creating and maintaining a database, reviewing database statements, data types, insert, update, delete, load/unload, dbexport/dbimport, locking, and select. Then take a close look at the 4GL programming environment, both r4gl and c4gl, including:

• Program structure
• Data types and definitions
• Menus, output, and much more

Programming Informix SQL/4GL presents detailed, end-to-end coverage of screen forms, options, creating context-sensitive help, and error handling. You'll learn how to make the most of advanced Informix capabilities, including user-defined searches, input array statements, complex screen I/O, matrix, and multi-part reporting, stored procedures, and triggers. Discover sophisticated SQL techniques, including views, synonyms, aggregates, subqueries, and query optimization. Learn how and when to mix C with 4GL. This new edition includes a full chapter on the INFORMIX-4GL Interactive Debugger.

If you need an in-depth understanding of the realities of Informix database programming, you don't have to wade through all those huge Informix manuals. All the answers are right here—in Programming Informix SQL/4GL.

Anyone who has used Informix manuals knows their indexes can be difficult to use because there are so many of them and sometimes the references are quite difficult to locate if they are there at all. Programming Informix SQL/4GL includes a comprehensive index making topics easy to find.

From the Inside Flap

Preface Conventions used in this book.

About This Book.

Are you tired of wading through all those Informix manuals? This book will take you step-by-step from database design to working with Informix's implementation of SQL, and finally, to implementing programs in INFORMIX¨-4GL. Topics are discussed in the order in which you will need to know the material. There are plenty of examples. The index is comprehensive. The chapter summaries provide a useful reference. The CD-ROM included with the book includes code examples from this book, and more. The book has been revised and updated to cover the most recent Informix product features, plus a whole new chapter on the INFORMIX-4GL Interactive Debugger.

This book takes on the broad task of describing how to design and develop a database application using Informix's implementation of SQL and INFORMIX-4GL. The first chapter of the book contains an overview of relational database design. The next few chapters (2-6) show you how to create and maintain an Informix database, and explains the use of all the basic commands in Informix's implementation of SQL. Chapters 9-19 cover basic INFORMIX-4GL in an order designed to get you up and working quickly. Chapter 19 explains how to use Informix's version of SQL in INFORMIX-4GL and is followed by two chapters of advanced SQL topics. The rest of the book includes more advanced INFORMIX-4GL topics, including user defined searches, more complex screen input/output, report writing, the debugger and using INFORMIX-4GL with C.

Going through this book chapter by chapter will allow you to design, create, maintain, and write applications for your own database system. The subjects are covered in the order in which you will typically need them when building a new system. A comprehensive table of contents and index allow quick reference to specific topics. A summary at the end of each chapter provides a quick reference for all the syntax and information covered in each chapter.

Please feel free to e-mail any comments about this book to the author, Cathy Kipp (ckipp@verinet).

Edition details

• Publisher: Prentice Hall Ptr
• Publication date: 1997
• ISBN 10: 013675919X
• ISBN 13: 9780136759195
• Binding: Paperback
• Language: English
• Number of pages: 697