Informix Guide to SQL: Tutorial Modifying Data Through SQL Programs

The previous chapter describes how to insert or embed SQL statements, especially the SELECT statement, into programs written in other languages. Embedded SQL enables a program to retrieve rows of data from a database.

This chapter discusses the issues that arise when a program needs to delete, insert, or update rows to modify the database. As in Chapter 7, this chapter prepares you for reading your Informix embedded language manual.

The general use of the INSERT, UPDATE, and DELETE statements is discussed in Chapter 6. This chapter examines their use from within a program. You can easily embed the statements in a program, but it can be difficult to handle errors and to deal with concurrent modifications from multiple programs.