Simple data manipulation is a programming technique used to
SELECT or INSERT
a single row. It can also be used to INSERT, DELETE, or
UPDATE one or more rows based on a specific criterion.
These types of data manipulation operations are considered
simple because they can be done with SQL data manipulation
commands that:
Do not contain the BULK option; therefore
the host variables used are not arrays, and data references
are simplified.
Are not executed in conjunction with a cursor; therefore
additional SQL commands such as FETCH and OPEN are not required.
Are not dynamically preprocessed; and therefore, additional arrays
and SQL commands are not required to execute them.
This chapter reviews how to use the SELECT, INSERT, DELETE, and
UPDATE commands
for simple data manipulation. It then briefly examines transaction
management considerations. For further discussion of transaction
management, refer to the ALLBASE/SQL Reference Manual .
A program illustrating simple data manipulation is found at the end of
the chapter.