Modify 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 SQL programming, this chapter prepares you for reading your HCL® OneDB® embedded language publication.

The general use of the INSERT, UPDATE, and DELETE statements is discussed in Modify 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.