In This Chapter
The preceding chapter introduced the idea of putting 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 covers the issues that arise when a program needs to modify the database by deleting, inserting, or updating rows. Like Chapter 5, "Programming with SQL," this chapter aims to prepare you for reading the manual for your Informix embedded language.
The general use of the INSERT, UPDATE, and DELETE statements is covered in Chapter 4, "Modifying Data." This chapter examines their use from within a program. You can easily put the statements in a program, but it can be difficult to handle errors and to deal with concurrent modifications from multiple programs.
|
