Informix Guide to SQL: Tutorial Modifying Data Through SQL Programs

In This Chapter

Using DELETE

Direct Deletions

Errors During Direct Deletions

Using Transaction Logging

Coordinated Deletions

Deleting with a Cursor

Using INSERT

Using an Insert Cursor

Declaring an Insert Cursor

Inserting with a Cursor

Status Codes After PUT and FLUSH

Rows of Constants

An Insert Example

Using UPDATE

Using an Update Cursor

The Purpose of the Keyword UPDATE

Updating Specific Columns

UPDATE Keyword Not Always Needed

Cleaning Up a Table

Summary