Programming Informix SQL/4GL: A Step-by-Step Approach - Softcover

Kipp, Cathy

Softcover

ISBN 10: 0131493949 ISBN 13: 9780131493940

Publisher: Prentice Hall, 1994

Synopsis

This beginner's guide to developing applications using Informix SQL and 4GL is designed for those with some programming experience, but little to moderate experience with databases and/or Informix. It serves as a tutorial on database design, Informix SQL, and Informix 4GL - showing developers through step-by-step instructions, how to design, create, maintain, and write applications for a database system. It covers each topic in the order in which a developer would need them when building a new system. and to those developing applications in a Windows environment.

About this title

Product Description

Programming Informix Sql/4gl: A Step-by-step Approach

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: 1994
• ISBN 10: 0131493949
• ISBN 13: 9780131493940
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 496