Picture 1 of 1

Gallery
Picture 1 of 1

Programming Informix SQL/4GL: A Step-By-Step Approach (Bk/CD) [With Contains...
by Kipp, Cathy | PB | VeryGood
US $14.15
Approximately£10.39
Condition:
“May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend ”... Read moreAbout condition
Very Good
A book that has been read and does not look new, but is in excellent condition. No obvious damage to the book cover, with the dust jacket (if applicable) included for hard covers. No missing or damaged pages, no creases or tears, no underlining or highlighting of text, and no writing in the margins. Some identifying marks on the inside cover, but this is minimal. Very little wear and tear. See the seller’s listing for full details and description of any imperfections.
Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
Postage:
Free USPS Media MailTM.
Located in: Aurora, Illinois, United States
Delivery:
Estimated between Wed, 18 Jun and Wed, 25 Jun
Returns:
30 days return. Seller pays for return postage.
Payments:
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:376074252370
Item specifics
- Condition
- Very Good
- Seller notes
- Binding
- Paperback
- Book Title
- Programming Informix SQL/4GL
- Weight
- 1 lbs
- Product Group
- Book
- IsTextBook
- Yes
- ISBN
- 9780136759195
About this product
Product Identifiers
Publisher
Prentice Hall PTR
ISBN-10
013675919X
ISBN-13
9780136759195
eBay Product ID (ePID)
10038280219
Product Key Features
Number of Pages
512 Pages
Language
English
Publication Name
Programming Informix Sql 4gl : a Step-By-Step Approach
Publication Year
1997
Subject
Programming Languages / General, Desktop Applications / Databases, Databases / General
Type
Textbook
Subject Area
Computers
Series
Prentice Hall Ptr Informix Ser.
Format
Trade Paperback
Dimensions
Item Height
1.8 in
Item Weight
48.6 Oz
Item Length
9.3 in
Item Width
7 in
Additional Product Features
Edition Number
2
Intended Audience
Scholarly & Professional
LCCN
97-034776
Dewey Edition
21
Illustrated
Yes
Dewey Decimal
005.75/65
Table Of Content
1. Relational Database Design. What is a Relational Database? Elements of a Database: Tables, Columns, and Rows. Tables. Columns. Rows. Primary Keys. Foreign Keys. Types of Relationships. One-to-One or Zero. One-to-Many (or Many-to-One). Many-to-Many. What Is Normalization? Formal Normalization. First Normal Form. Second Normal Form. Third Normal Form. Intuitive Normalization. Indexing Strategies. Composite Indexes. Unique Indexes. Duplicate Indexes. Shorter Is Better. Numeric versus Character Indexes. Clustered Indexes. Small Tables. Description of the Sample Database. Summary. 2. The SQL Working Environment. About Informix's Implementation of SQL. About DB-Access. Setting UNIX Environment Variables. Environment Variables Needed by Informix. Optional Environment Variables. Using DB-Access. DB-Access Options with Ring Menus. Getting Around in Informix Ring Menus. Choosing Options from a List. Working From the Command Line. Viewing Error Messages. Summary. 3. Creating the Database. The Database Administrator. INFORMIX Database Engines. Database Statements. Data Types. Character and String Data Types. Numer Data Types. Date, Time, and Interval Data Types. Extra data types for INFORMIX-OnLine. Summary of Data Type Conversions. Tables. Creating a New Table. Changing an Existing Table. Deleting a Table. Renaming Tables and Columns. Privileges. Granting Database Privileges. Granting Table Privileges. Revoking Privileges. Roles. Creating Schema Authorization. Indexes. Creating the Sample Database. Viewing the Database. Summary. 4. Maintaining the Database. Update Statistics. Checking Database Integrity. INFORMIX-SE Database Integrity. INFORMIX-OnLine Database Integrity. Database Backups. INFORMIX-SE Backups. INFORMIX-OnLine Backups. Logging. What Is a Transaction? Transaction Logging in INFORMIX-SE. Transaction Logging in INFORMIX-OnLine. Audit Trails-INFORMIX-SE Only. Summary. 5. Data: Adding, Changing, and Deleting. Insert. Update. Delete. Locking. Locking a Database. Locking a Table. Set Lock Mode. INFORMIX-OnLine Table Option. Load and Unload. Loading Data. Unloading Data. dbload. The Command File. Examples. dbexport and dbimport. dbexport. dbimport. Tips for Faster Data Loads. Summary. 6. The Select Statement. Overview of the Select Statement. Select. From. Where. Conditional Expressions. Matches and Like. Other Conditionals. Group By. Having. Order By. Into Temp. Union. Joins. Outer Joins. Output To. Summary. 7. The 4GL Programming Environment. INFORMIX-4GL Flavors: r4gl and c4gl. INFORMIX-4GL File Name Suffixes. Menu Driven Development. Command Line Development. Compiling and Running 4GL Code in the Rapid Development System. Compiling and Running Compiled 4GL Code. Compiling Informix Screen Forms. Make Files. Make Rules. The Make File. Prototyping. Summary. 8. 4GL Program Structure. Overview. Database. Globals. Main. Modules. Functions. Exit Program. Comments. Summary. 9. Data Types and Definitions. 4GL Data Types. Character and String Data Types. Numeric Data Types. Date, Time, and Interval Data Types. BLOB Data Types. INFORMIX-4GL Only Data Types and Indirect Typing. Defining Variables. Scope of Variables. Use of Nulls. Operators in 4GL. Converting between Data Types. Character and String Data Types. Numeric Data Types. Date, Time, and Interval Data Types. Formatting Data with the using Clause. Formatting Dates. Formatting Numbers. Summary. 10. Menus. Overview of Menus. A Simple Ring Menu. Menu Simplicity and Consistency. Menu Features. Command Keys. Help. Next Option. Continue Menu. Hidden Menu Options. Hide Option. Show Option. Before Menu. Summary. 11. Output and Standard Program Statements. <
Synopsis
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-, 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., 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.
LC Classification Number
QA76.9.D3K498 1998
Item description from the seller
Seller business information
About this seller
ThriftBooks
98.9% positive Feedback•19.5M items sold
Registered as a business seller
Popular categories from this shop
Seller Feedback (5,651,488)
- l***l (6197)- Feedback left by buyer.Past 6 monthsVerified purchaseI must say from the very beginning of this transaction that everything went smooth. The seller gave me a good quality product for a great price that was brand new and appeared to be better than what was pictured. I plan on purchasing more products in the near future from this seller. The product was shipped and packaged with care and love. Magnificent communication and all of what I said makes this seller a great asset to the eBay community as well as the marketplace.
- y***e (1043)- Feedback left by buyer.Past 6 monthsVerified purchase🏆 SUPER STAR🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 AAAA
- k***a (61)- Feedback left by buyer.Past monthVerified purchaseFantastic seller. Books were packaged safely & with love, and as described. Great deal for the money considering the condition they’re in. Shipping was lighting fast. I’d recommend this seller & will be shopping again. The quality & selection of there rare/collectible books is unmatched, and the flexibility on price is the icing on the cake. +1 for great communication.
More to explore:
- Non-Fiction Fiction & Neuro-Linguistic Programming Books,
- Non-Fiction Paperback Fiction & Game Programming Books,
- Non-Fiction Game Programming Fiction & Non-Fiction Books,
- Non-Fiction Paperback Fiction & Neuro-Linguistic Programming Books,
- Non-Fiction Programming Languages Fiction & Non-Fiction Books,
- Audio CD Books,
- Unabridged CD Audio Books,
- German Audio CD books,
- Audiobook CD Audio Books,
- Italian Audio CD books