HP 3000 Manuals HP 3000 Manuals
Chapter 7 Simple Data Manipulation
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.