Informix Guide to SQL: Tutorial
Chapter 6: Modifying Data Through SQL Programs
Home
Contents
Index
Master Index
New Book
Modifying Data Through SQL Programs
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
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
