Programming Informix SQL/4GL
Home > Computing and Information Technology > Databases > Database software > Programming Informix SQL/4GL: A Step-By-Step Approach (Bk/CD)
Programming Informix SQL/4GL: A Step-By-Step Approach (Bk/CD)

Programming Informix SQL/4GL: A Step-By-Step Approach (Bk/CD)

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

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.

Table of Contents:
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. Overview. Assignment. Output. Display. Error. Message. Prompt. Sleep. Conditionals. If-then-else. case. Looping. for. while. goto-label. Running UNIX Commands. Summary. 12. Screen Forms. What Is a Screen Form? Screen Form Design. Screen Form Implementation. Database. Screen. Tables. Attributes. Instructions. Example of an INFORMIX-4GL-Generated Form. Example of a Modified Generated Form. Single Record Form. Multiple Record Form. Combination Form. Form Attributes. upscol. Summary. 13. Adding Forms and Windows & Displaying Data. Window Handling. Displaying Forms. Overview of Display. Display. Display Example. Sample Module. Display Array. Display Array Example. Scroll. Sample Module. Display a One-to-Many Relationship. Summary. 14. Setting Options. Overview of Options. Output Lines. Keys. Help File. Attributes. Input Wrap. Field Order. Sql Interrupt. Line or Form Mode. Example. Summary. 15. Help! About Context-Sensitive Help. Help Files. mkmessage. Using Help. Summary. 16. Error Handling. Defer Interrupt. Defer Quit. Whenever. Error Log. Sample Main Program and Error Function. Summary. 17. Built-in Functions, Constants, and Variables. INFORMIX-4GL Functions Called from 4GL. INFORMIX-4GL Functions Called from C. INFORMIX-4GL Constants. INFORMIX-4GL Global Variables. Summary. 18. The Input Statement. Input Overview. Editing the Input. Data Validation. Adding/Changing a Row. Summary. 19. Using SQL in 4GL. Using Direct SQL in 4GL. prepare. execute. declare. foreach. open. fetch. where current of. put. flush. close. free. Summary. 20. More Sophisticated SQL. Views. Synonyms. Expressions. Operators. Columns. Literal Constants. Built-in Functions. Aggregates. Using Aggregate Functions. Subqueries. Subqueries with Relational Operators. in and not in. exists and not exists. all, any, and some. insert. update. delete. Self-Joins. Query Optimization. Set explain on. Temp Tables. or versus union. Indexes. Forcing Use of Indexes. Pattern Matching and Substrings. Subqueries. INFORMIX-OnLine Topics. Accessing Tables in Other Databases on the Same INFORMIX-OnLine System. Isolation Levels. Summary. 21. Stored Procedures and Triggers. Stored Procedures. dbinfo. Sample Stored Procedures. Privileges. Changing and Deleting Existing Stored Procedures. Update Statistics. Triggers. Examples. Looking at Existing Triggers. Changing and Deleting Existing Stored Procedures. Summary. 22. User-Defined Searches. Overview. From the User's Perspective. Constructing a where Clause. Construct Features. Completing the select Statement. Sample Function. Summary. 23. The Input Array Statement. Input Array Overview. 4GL Functions. Editing the Input. Data Validation. Sample Function. Summary. 24. Input of a One-to-Many Relationship. One-to-Many Input Overview. Sample Module. Summary. 25. Basic Report Writing. Report Overview. Getting the Report Data. Formatting the Report. Output. Order by. Control Blocks. On every row. Headers and Footers. Aggregates. Grouping. Final Totals. Sample Report. Summary. 26. Complex Reports. Using Temp Tables, Unions, and Other SQL Tricks. Matrix Reports. Multi-Part Reports. Summary. 27. The 4GL Debugger. Overview. Get Me Started, Quick! Environment. DBSRC. Debugger Files (.4db). fgldb Command Line Options. Creating a Custom Debugger Runner. Debugger Commands. Summary. 28. Mixing C and 4GL. Calling C Functions from 4GL. Linking Compiled 4GL Code. Linking Rapid Development System Code. Calling 4GL Functions from C. Linking Compiled 4GL Code. Linking Rapid Development System Code. Summary. Appendix A. INFORMIX-4GL Functions Called from C. Appendix B. CD Contents and Contributors. CD Contents. Software Contributors. Bibliography and Other Informix Books from Prentice Hall PTR. Books on Informix. Informix Manuals. General Database. Index.


Best Sellers


Product Details
  • ISBN-13: 9780136759195
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Height: 235 mm
  • No of Pages: 512
  • Sub Title: A Step-By-Step Approach (Bk/CD)
  • Width: 177 mm
  • ISBN-10: 013675919X
  • Publisher Date: 10 Dec 1997
  • Binding: Paperback
  • Language: English
  • Spine Width: 45 mm
  • Weight: 1377 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Programming Informix SQL/4GL: A Step-By-Step Approach (Bk/CD)
Pearson Education (US) -
Programming Informix SQL/4GL: A Step-By-Step Approach (Bk/CD)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Programming Informix SQL/4GL: A Step-By-Step Approach (Bk/CD)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!