Home | Previous Page | Next Page

Modifying Data

In This Chapter

Modifying Your Database

Deleting All Rows of a Table

Deleting All Rows using TRUNCATE TABLE

Deleting Rows from a Supertable using TRUNCATE TABLE

Deleting Specified Rows

Deleting Selected Rows

Deleting Rows That Contain Row Types (IDS)

Deleting Rows That Contain Collection Types (IDS)

Deleting Rows from a Supertable (IDS)

Complicated Delete Conditions

Using a Delete Join (XPS)

Possible Column Values

Restrictions on Column Values

Serial Data Types

Listing Specific Column Names

Inserting Rows into Typed Tables (IDS)

Inserting into Row-Type Columns (IDS)

Rows That Contain Named Row Types

Rows That Contain Unnamed Row Types

Specifying Null Values for Row Types

Inserting Rows into Supertables (IDS)

Inserting Collection Values into Columns (IDS)

Inserting into Simple Collections and Nested Collections

Inserting Null Values into a Collection That Contains a Row Type

Inserting Smart Large Objects (IDS)

Multiple Rows and Expressions

Restrictions on the Insert Selection

Selecting Rows to Update

Updating with Uniform Values

Restrictions on Updates

Updating with Selected Values

Updating Row Types (IDS)

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 (IDS)

Updating Rows of a Supertable (IDS)

Using a CASE Expression to Update a Column

Using SQL Functions to Update Smart Large Objects (IDS)

Using a Join to Update a Column

Privileges on a Database and on its Objects

Database-Level Privileges

Table-Level Privileges

Displaying Table Privileges

Granting Privileges to Roles

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

Transaction Logging

Transaction Logging for Extended Parallel Server

Logging and Cascading Deletes

Specifying Transactions

Backups and Logs with Informix Database Servers

Concurrency and Locks

IBM Informix Data Replication (IDS)

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]