Informix Guide to SQL: Tutorial 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

Using a Join to Delete Rows

Inserting Rows

Single Rows

Possible Column Values

Listing Specific Column Names

Inserting Rows into Typed Tables

Inserting into Row-Type Columns

Rows That Contain Named Row Types

Rows That Contain Unnamed Row Types

Specifying Null Values for Row Types

Inserting Rows into Supertables

Inserting Collection Values into Columns

Inserting into Simple Collections and Nested Collections

Inserting Null Values into a Collection That Contains
a Row Type

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 Rows That Contain Named Row Types

Updating Rows That Contain Unnamed Row Types

Specifying Null Values for the Fields of a Row Type

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

Using the ON DELETE CASCADE Option

Example of Cascading Deletes

Restrictions on Cascading Deletes

Object Modes and Violation Detection

Definitions of Object Modes

Example of Modes with Data Manipulation Statements

Violations and Diagnostics Tables

Interrupted Modifications

Transactions

Transaction Logging

Transaction Logging for Enterprise Decision Server

Logging and Cascading Deletes

Specifying Transactions

Backups and Logs with Informix Database Servers

Concurrency and Locks

Informix Data Replication

Summary