Informix Guide to SQL

Informix Guide to SQL : Tutorial

3 (1 rating by Goodreads)
By (author) 

List price: US$41.00

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

Master the Informix implementation of SQL, start-to-finish-updated for the new Informix Dynamic Server.2000 and Informix Enterprise Decision Server! The Informix Guide to SQL: Tutorial, Second Edition is the authoritative, complete tutorial for learning the Informix implementation of SQL-completely updated for Informix Dynamic Server.2000 and Informix Enterprise Decision Server. Starting with the simplest SELECT statements, this complete course walks you through everything you need to know to succeed with SQL. Learn how to build and optimize queries, both simple and advanced. Use SQL statements to insert, delete, or update data, while you maintain data integrity and security. Learn how to call the database server, retrieve rows, embed data, and create and implement efficient data models, step-by-step. Coverage includes all this, and more: * Fundamental relational and object-relational database concepts * User access and security through GRANT, REVOKE, CREATE VIEW and other SQL statements * SQL Programming techniques, including dynamic SQL and embedded data definition statements * Complex data types, including collection types, row types, and inheritance hierarchies * Data manipulatshow more

Product details

  • Paperback | 350 pages
  • 177.8 x 233.68 x 17.78mm | 498.95g
  • Pearson Education (US)
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 2nd edition
  • 0130161659
  • 9780130161659

Table of contents

Introduction. About This Manual. Types of Users. Software Dependencies. Assumptions. About Your Locale. Demonstration Databases. New Features. New Features in Version 8.3. New Features in Version 9.2. Documentation Conventions. Typographical Conventions. Icon Conventions. Sample-Code Conventions. Additional Documentation. On-Line Manuals. Printed Manuals. On-Line Help. Error Message Documentation. Documentation Notes, Release Notes, Machine Notes. Related Reading. Compliance with Industry Standards. Informix Welcomes Your Comments.1. Database Concepts in This Chapter. Illustration of a Data Model. Storing Data. Querying Data. Modifying Data. Concurrent Use and Security. Controlling Database Use. Centralized Management. Important Database Terms. The Object-Relational Model. Tables. Columns. Rows. Operations on Tables. The Object-Relational Model. Structured Query Language. Standard SQL. Informix SQL and ANSI SQL. Interactive SQL. General Programming. ANSI-Compliant Databases. GLS Databases. Summary.2. Composing SELECT Statements in This Chapter. Introducing the SELECT Statement. Some Basic Concepts. The Forms of SELECT. Special Data Types. Single-Table SELECT Statements. Selecting All Columns and Rows. Selecting Specific Columns. Using the WHERE Clause. Creating a Comparison Condition. Using a FIRST Clause to Select Specific Rows. Expressions and Derived Values. Using Rowid Values in SELECT Statements. Multiple-Table SELECT Statements. Creating a Cartesian Product. Creating a Join. Some Query Shortcuts. Selecting Tables from a Database Other Than the Current Database. Summary.3. Selecting Data from Complex Types in This Chapter. Selecting Row-Type Data. Selecting Columns of a Typed Table. Selecting Columns That Contain Row-Type Data. Selecting from a Collection. Selecting Nested Collections. Using the IN Keyword to Search for Elements in a Collection. Selecting Rows Within a Table Hierarchy. Selecting Rows of the Supertable Without the ONLY Keyword. Selecting Rows from a Supertable with the ONLY Keyword. Using an Alias for a Supertable. Summary.4. Using Functions in Select Statements in This Chapter. Using Functions in SELECT Statements. Aggregate Functions. Time Functions. Date-Conversion Functions. Cardinality Function. Smart-Large-Object Functions. String-Manipulation Functions. Other Functions. Using SPL Routines in SELECT Statements. Using Rowid Values in SELECT Statements. Using Rowid Values with the USER Function. Using Rowid Values with the DBSERVERNAME Function. Summary.5. Composing Advanced SELECT Statements in This Chapter. Using the GROUP BY and HAVING Clauses. Using the GROUP BY Clause. Using the HAVING Clause. Creating Advanced Joins. Self-Joins. Outer Joins. Subqueries in SELECT Statements. Subqueries in a Select List. Subqueries in WHERE Clauses. Handling Collections in SELECT Statements. Collection Subqueries. Collection-Derived Tables. Set Operations. Union. Difference. Summary.6. Modifying Data in This Chapter. Statements That Modify Data. Deleting Rows. Deleting All Rows of a Table. Deleting a Known Number of Rows. Deleting an Unknown Number of Rows. Deleting Rows That Contain Row Types. Deleting Rows That Contain Collection Types. Deleting Rows from a Supertable. Complicated Delete Conditions. Inserting Rows. Single Rows. Inserting Rows into Typed Tables. Inserting into Row-Type Columns. Inserting Rows into Supertables. Inserting Collection Values into Columns. Inserting Smart Large Objects. Multiple Rows and Expressions. Restrictions on the Insert Selection. Updating Rows. Selecting Rows to Update. Updating with Uniform Values. Restrictions on Updates. Updating with Selected Values. Updating Row Types. Updating Collection Types. Updating Rows of a Supertable. Using a CASE Expression to Update a Column. Using SQL Functions to Update Smart Large Objects. Using a Join to Update a Column. Privileges on a Database. Database-Level Privileges. Table-Level Privileges. Displaying Table Privileges. Data Integrity. Entity Integrity. Semantic Integrity. Referential Integrity. Object Modes and Violation Detection. Interrupted Modifications. Transactions. Transaction Logging. Specifying Transactions. Backups and Logs with Informix Database Servers. Concurrency and Locks. Informix Data Replication. Summary.7. Programming with SQL in This Chapter. SQL in Programs. SQL in SQL APIs. SQL in Application Languages. Static Embedding. Dynamic Statements. Program Variables and Host Variables. Calling the Database Server. SQL Communications Area. SQLCODE Field. SQLERRD Array. SQLWARN Array. SQLERRM Character String. SQLSTATE Value. Retrieving Single Rows. Data Type Conversion. Working with Null Data. Dealing with Errors. Retrieving Multiple Rows. Declaring a Cursor. Opening a Cursor. Fetching Rows. Cursor Input Modes. Active Set of a Cursor. Using a Cursor: A Parts Explosion. Dynamic SQL. Preparing a Statement. Executing Prepared SQL. Dynamic Host Variables. Freeing Prepared Statements. Quick Execution. Embedding Data-Definition Statements. Embedding Grant and Revoke Privileges. Summary.8. Modifying Data through SQL Programs in This Chapter. Using DELETE. Direct Deletions. Deleting with a Cursor. Using INSERT. Using an Insert Cursor. Rows of Constants. An Insert Example. Using UPDATE. Using an Update Cursor. Cleaning Up a Table. Summary.9. Programming for a Multiuser Environment in This Chapter. Concurrency and Performance. Locking and Integrity. Locking and Performance. Concurrency Issues. How Locks Work. Kinds of Locks. Lock Scope. Duration of a Lock. Locks While Modifying. Locking with the SELECT Statement. Setting the Isolation Level. Update Cursors. Retaining Update Locks. Locks Placed with INSERT, UPDATE, and DELETE. Understanding the Behavior of the Lock Types. Controlling Data Modification with Access Modes. Setting the Lock Mode. Waiting for Locks. Not Waiting for Locks. Waiting a Limited Time. Handling a Deadlock. Handling External Deadlock. Simple Concurrency. Hold Cursors. Using the SQL Statement Cache. Summary.10. Creating and Using SPL Routines in This Chapter. Introduction to SPL Routines. What You Can Do with SPL Routines. SPL Routine Behavior for Enterprise Decision Server. Writing SPL Routines. Using the CREATE PROCEDURE or CREATE FUNCTION Statement. Example of a Complete Routine. Creating an SPL Routine in a Program. Dropping an SPL Routine. Defining and Using Variables. Declaring Local Variables. Declaring Global Variables. Assigning Values to Variables. Expressions in SPL Routines. Writing the Statement Block. Implicit and Explicit Statement Blocks. Using Cursors. Using the FOREACH Loop to Define Cursors. Using an IF - ELIF - ELSE Structure. Adding WHILE and FOR Loops. Exiting a Loop. Returning Values from an SPL Function. Returning a Single Value. Returning Multiple Values. Handling Row-Type Data. Precedence of Dot Notation. Updating a Row-Type Expression. Handling Collections. Collection Examples. The First Steps. Declaring a Collection Variable. Declaring an Element Variable. Selecting a Collection into a Collection Variable. Inserting Elements into a Collection Variable. Selecting Elements from a Collection. Deleting a Collection Element. Updating a Collection Element. Updating the Entire Collection. Inserting into a Collection. Executing Routines. Using the EXECUTE Statements. Using the CALL Statement. Executing Routines in Expressions. Executing an External Function with the RETURN Statement. Executing Cursor Functions from an SPL Routine. Dynamic Routine-Name Specification. Privileges on Routines. Privileges for Registering a Routine. Privileges for Executing a Routine. Privileges on Objects Associated with a Routine. DBA Privileges for Executing a Routine. Finding Errors in an SPL Routine. Looking at Compile-Time Warnings. Generating the Text of the Routine. Debugging an SPL Routine. Exception Handling. Trapping an Error and Recovering. Scope of Control of an ON EXCEPTION Statement. User-Generated Exceptions. Checking the Number of Rows Processed in an SPL Routine. Summary.11. Creating and Using Triggers in This Chapter. When to Use Triggers. How to Create a Trigger. Assigning a Trigger Name. Specifying the Trigger Event. Defining the Triggered Actions. A Complete CREATE TRIGGER Statement. Using Triggered Actions. Using BEFORE and AFTER Triggered Actions. Using FOR EACH ROW Triggered Actions. Using SPL Routines as Triggered Actions. Triggers in a Table Hierarchy. Using Select Triggers. SELECT Statements that Execute Triggered Actions. Restrictions on Execution of Select Triggers. Select Triggers on Tables in a Table Hierarchy. Re-Entrant Triggers. Tracing Triggered Actions. Example of TRACE Statements in an SPL Routine. Example of TRACE Output. Generating Error Messages. Applying a Fixed Error Message. Generating a Variable Error Message. Summary.Index.show more

Rating details

1 ratings
3 out of 5 stars
5 0% (0)
4 0% (0)
3 100% (1)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X