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 Programming with SQL, this chapter prepares you for reading your IBM Informix embedded language manual.
The general use of the INSERT, UPDATE, and DELETE statements is discussed in Modifying Data. 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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]