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

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $16.80
Usually ships in 1-2 business days
(Save 66%)
Other sellers (Paperback)
  • All (6) from $16.80   
  • New (1) from $109.06   
  • Used (5) from $16.8   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$109.06
Seller since Tue Jan 01 01:01:01 EST 2008

Feedback rating:

(194)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
013675919X New. Looks like an interesting title!

Ships from: Naperville, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780136759195
  • Publisher: Pearson Education
  • Publication date: 11/21/1997
  • Series: Informix Press Series
  • Edition number: 2
  • Pages: 697
  • Product dimensions: 7.02 (w) x 9.22 (h) x 1.86 (d)

Read an Excerpt

PREFACE: 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 usingINFORMIX-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.com).
Read More Show Less

Table of Contents

Preface
Acknowledgments
Ch. 1 Relational Database Design 2
Ch. 2 The SQL Working Environment 26
Ch. 3 Creating the Database 48
Ch. 4 Maintaining the Database 98
Ch. 5 Data: Adding, Changing, and Deleting 126
Ch. 6 The Select Statement 152
Ch. 7 The 4GL Programming Environment 180
Ch. 8 4GL Program Structure 196
Ch. 9 Data Types and Definitions 206
Ch. 10 Menus 222
Ch. 11 Output and Standard Program Statements 234
Ch. 12 Screen Forms 250
Ch. 13 Adding Forms and Windows & Displaying Data 276
Ch. 14 Setting Options 322
Ch. 15 Help! 334
Ch. 16 Error Handling 340
Ch. 17 Built-in Functions, Constants, and Variables 350
Ch. 18 The Input Statement 382
Ch. 19 Using SQL in 4GL 398
Ch. 20 More Sophisticated SQL 518
Ch. 21 Stored Procedures and Triggers 454
Ch. 22 User-Defined Searches 486
Ch. 23 The Input Array Statement 504
Ch. 24 Input of a One-to-Many Relationship 524
Ch. 25 Basic Report Writing 546
Ch. 26 Complex Reports 578
Ch. 27 The 4GL Debugger 600
Ch. 28 Mixing C and 4GL 628
App. A INFORMIX-4GL Functions Called from C 642
App. B CD Contents and Contributors 662
Bibliography and Other Informix Books from Prentice Hall PTR 670
Index 672
Read More Show Less

Preface

PREFACE: 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 andusingINFORMIX-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.com).
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted Wed May 15 00:00:00 EDT 2002

    Excellent Book

    This book have been the real solution to my Company.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)