Programming Informix SQL/4GL: A Step-By-Step Approach (Bk/CD) (Prentice Hall Ptr Informix Series) - Softcover

Kipp, Cathy

Softcover

ISBN 10: 013675919X ISBN 13: 9780136759195

Publisher: Prentice Hall, 1997

Synopsis

This is the second edition of Cathy Kipp's programming Informix SQL/4GL. It has been updated based on user comment we received on the first edition, and to cover changes in the Informix SQL/4GL languages. This book will use the more trade-oriented Informix Press design, and it will include a CD-ROM with various software packages for Informix programmers.

About this title

From the Back Cover

67591-8

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.

Edition details

• Publisher: Prentice Hall
• Publication date: 1997
• ISBN 10: 013675919X
• ISBN 13: 9780136759195
• Binding: Paperback
• Language: English
• Edition number: 2
• Number of pages: 512