Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Programming Informix SQL/4GL (Prentice Hall PTR Informix Series) Paperback – 21 Nov 1997


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback, 21 Nov 1997
£130.91 £14.77

Trade In Promotion



Product details

  • Paperback: 512 pages
  • Publisher: Prentice Hall; 2 edition (21 Nov 1997)
  • Language: English
  • ISBN-10: 013675919X
  • ISBN-13: 978-0136759195
  • Product Dimensions: 17.8 x 4.8 x 23.5 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 4,234,197 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

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.

Customer Reviews

5.0 out of 5 stars
5 star
1
4 star
0
3 star
0
2 star
0
1 star
0
See the customer review
Share your thoughts with other customers

Most Helpful Customer Reviews

Format: Paperback
This book is an excellent resource for a novice user of Informix. I give this one 2 thumbs up. Even my expert coworker peeks into it once in a great while.
My work place has the Informix books offered by the vendor which can be highly wordy and, for me, unreadable. Also, the book by Paul Mahler, "An Informix 4GL Tutorial" is pure crap. Or maybe the title should have been, "Mahler's Only Way To Do Informix--An Unapproachable approach".
I have used both the first and 2nd editions written by Cathy Kipp. The first edition used a smaller font, was easy to read and was more compact and, after using it as a beginner Informix programmer, I grew attached to it. When I started using the 2nd edition, it took me a while to get used to the larger font or the more spread out documentation. In other words, a command could be covered in a single page on the first edition making it easy to read, but it took 2 pages to cover the same command in the 2nd edition. However, the 2nd edition had more substance over all.
Warning to the buyer! The books page numbers in the index and the actual pages those references are located can be a couple pages off. AFter the index was written, a few more lines were added throughout the book. This screws with your ability to find an indexed item in the book. For example, the index says: Isolation Levels p.446 but the actual page is p.448,9. Although, the plus side is the index is very thorough and make finding needed commands easily (within a page or 2).
Drawback #2, as with most large paperbacks that are used on a daily basis, the book will start falling apart--pages unglueing out of the binder after a few months to a year.
But again, it has definitely been an excellent resource.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 2 reviews
27 of 27 people found the following review helpful
This Book Is An Excellent Starting Point for New Users 24 April 1999
By James Butterfield - Published on Amazon.com
Format: Paperback
This book is an excellent resource for a novice user of Informix. I give this one 2 thumbs up. Even my expert coworker peeks into it once in a great while.
My work place has the Informix books offered by the vendor which can be highly wordy and, for me, unreadable. Also, the book by Paul Mahler, "An Informix 4GL Tutorial" is pure crap. Or maybe the title should have been, "Mahler's Only Way To Do Informix--An Unapproachable approach".
I have used both the first and 2nd editions written by Cathy Kipp. The first edition used a smaller font, was easy to read and was more compact and, after using it as a beginner Informix programmer, I grew attached to it. When I started using the 2nd edition, it took me a while to get used to the larger font or the more spread out documentation. In other words, a command could be covered in a single page on the first edition making it easy to read, but it took 2 pages to cover the same command in the 2nd edition. However, the 2nd edition had more substance over all.
Warning to the buyer! The books page numbers in the index and the actual pages those references are located can be a couple pages off. AFter the index was written, a few more lines were added throughout the book. This screws with your ability to find an indexed item in the book. For example, the index says: Isolation Levels p.446 but the actual page is p.448,9. Although, the plus side is the index is very thorough and make finding needed commands easily (within a page or 2).
Drawback #2, as with most large paperbacks that are used on a daily basis, the book will start falling apart--pages unglueing out of the binder after a few months to a year.
But again, it has definitely been an excellent resource. I almost would give this one 4 stars except, compared to the couple other resources I have seen, this one beats all the rest. Even if it has its couple of flaws.
If you have any questions, I will be more than happy to respond.
8 of 10 people found the following review helpful
Excellent Source for 4GL Development 10 Feb 2000
By A Customer - Published on Amazon.com
Format: Paperback
This is an excellent reference for anyone who is involved with Informix 4GL development. The book provides all the basics of SQL and 4GL. I often use it from time to time for my development projects.
Were these reviews helpful? Let us know


Feedback